Google sheet database

Design help CMS
1

Hey guys,
I have been looking into using webflow as a ‘live’ website. I would love to pull data into webflow from a googlesheet into the CMS and live update. Am I dreaming?

Here is my public share link: LINK
(how to access public share link)

2

Not at all. Look into zapper or Integromat. You could also use the api, but that would require some programming knowledge.

1 Like
3

You can definitely do it with Zapier or Integromat.

I’m just putting it out there, but If you data was in Airtable instead of googlesheets, then I have a turn-key solution for you at PowerImporter. It’s a ready-to-run workflow that syncs Airtable to Webflow. You simply map your Airtable columns to your Webflow CMS collection fields, and all the complexity of keeping them in sync is done for you, e.g., converting column data, looking up ref/multi-ref fields, uploading images, etc.

But if you can’t migrate from Google Sheets, signup for PowerImporter and I’ll notify you when my Google Sheets to Webflow sync feature is ready (it’s on my roadmap).

1 Like
5

Hey @Tufi_Sele! It’s been a while since this post, so I imagine you’ve already figured out a solution here, but if not lmk! We’re going to launch a Google Sheets x Webflow connection soon for Whalesync that will let you update Webflow data in real-time from GSheets. Would love to get you early access if interested.

6

Hi @Tufi_Sele
A common workflow amongst Webflow developers is connecting Google Sheets to a Webflow form submission. This allows user data to be stored in a spreadsheet, easily accessible to the rest of the team. Another option is to add Webflow CMS items (like blog posts) from new rows in a Google Sheet. These workflows are all automatons that can be set up using Zapier. You can find out how to do this here: https://zapier.com/apps/google-sheets/integrations/webflow

For a live demo, have a look at this Webflow cloneable : https://showcased.webflow.io/projects/bl-showcase-google-sheets-integration. Simply fill in the form, head over to the Google Sheet page, and watch the spreadsheet update with you submission.

You mentioed you wanted to have your databse in your Webflow website, well you can embed it direclty. You can do this via Udesly, a tool that allows you to connect various with Webflow.

Google Sheets - Webflow Tools - Udesly]
To view a sample of this live, head over to: https://google-spreadsheet-cloneable.webflow.io/#sample

7

Hi @Tufi_Sele,

I noticed your post. It’s been a long time since you posted this and hopefully, it’s solved. If it’s not. I wanted to reach out to you to let you know I have built a plugin to solve this same problem.

  1. Getting past CMS data from Webflow to Google Sheets
  2. Automatically updating CMS items in Google Sheets daily.

I would love to get in touch with you and offer you the product for free!

Thanks,
Vinayak

1 Like
8

does powerimporter work with google sheets yet?

9

tell me more about this plugin you have

10

Late to the party, but there’s now a simpler option for this use case.

If you don’t need CMS sync (i.e., SEO isn’t critical for this data), you can skip Zapier/Make entirely and just fetch the data client-side.

GetSheetAPI turns your Google Sheet into a REST API endpoint. You point it at your sheet, get a JSON URL back, and fetch it with a few lines of JavaScript in Webflow’s custom code.

fetch('https://api.getsheetapi.com/v1/your-sheet-id')
  .then(res => res.json())
  .then(data => {
    // render your data
  });

When to use this approach:

  • Data changes frequently and you want it always live
  • You don’t want to pay for Zapier/Make automations
  • SEO doesn’t matter for this content (testimonials, pricing tables, event listings, etc.)

When to stick with CMS sync:

  • You need the content indexed by search engines
  • You want to use Webflow’s built-in CMS features

The client-side approach is way simpler to maintain - no automations to debug.