Use Google Sheets as a database to show logged-in customers specific data related to them

Hello! I'm not an experienced developer, but I can usually muddle through.

Here's my question – we're looking to build a low/no code V1 of our web product. We're planning to create logins for them (on Squarespace) and they'll be submitting data to us via a form to start a new project, which we plan to house in a specific Google Sheet related to that customer. From the Google Sheet, we want to be able to update certain data behind the scenes (i.e. the project status), and we want the customer to be able to see this updated data along with data visualizations, etc. when they're logged into Squarespace. What this means is that when customers log in to Squarespace, they will need to see their specific data.

How can we:

• Connect a user's credentials to a specific Google Sheet
• Pull in the right data when they log in to the customer area via Squarespace

Is this even possible?

Thank you!

Hi. Replying to this a bit late I expect. But I'd be interested if this was solved, at least the part about matching the data to a specific user.

The solution to pulling the Google Sheet data is easy. I've just done this with a property developer client pulling in data for a list of home sites. Check out: https://chriszarate.github.io/sheetrock/#documentation

Sheetrock JS has many great features, including search and sort. I've used it in a simple table (responsive), but I sure you can style this data in lots of ways, so it doesn't necessarily look like a table.

I added to the Sheetrock JS to include some color styling if one piece of data matched a set criteria. Maybe if the user has a tag or ID you could target that, automatically filtering out everyone else. Sheetrock.js pulls in the entire Google Sheet to the page in order to filter it after loading and discards the data not needed, so if you look at the HTML in your page inspector, you see only the data that fits the filtered criteria. Pretty nice solution.

I'll try and post some more detail about Sheetrock JS and an example elsewhere in the forum under Custom Code soon.

Thanks, Simon! I appreciate the thoughtful response and I'm sure it will help others. We ended up taking a different approach and are using another tool for client portal capabilities. FWIW, I also looked into Zapier's Interfaces feature and ruled it out, but it does look promising.