How to integrate Google Sheets – Webflow bundle using Zapier?

Launch new pages on Webflow automatically when adding data to Google Sheets—just follow our guide. Save time and effort by updating your site without manual steps.

Creating a new Webflow page when a new row is created on Google Sheets

A step-by-step guide for integrating Google Sheets – Webflow bundle using Zapier

You can use Google Sheets to automatically generate content on your Webflow site, such as creating new pages, CMS elements, or content blocks. The basic idea is to store all data in Google Sheets and automatically feed it to Webflow via Zapier to create dynamic pages.

Usage example:

• If you add a new row in Google Sheets with data about a new product, Webflow will automatically create a new product page with the appropriate name, description, price, and image.
• If you update data in Google Sheets, the corresponding pages or elements on the Webflow site will also update automatically.

1. Google Sheets setup

• First, create a spreadsheet in Google Sheets that will contain data, like in the example:

1. Product Name
2. Description
3. Price
4. Image URL

• Fill up rows with some test data. 

2. Webflow setup.

• Create or login to your Webflow account.
• Create a new collection in which items will be created or updated (eg “Products”).

To create a collection, go to your Webflow and add a new collection.

Add the appropriate fields and save it

How the integration works:

• A new Google Sheets row is created;
• Zapier creates a new element in the “Products” collection on Webflow.

1. Click on “Create”: 

2. Select “Zaps”.

Adding a trigger event

3. Click on the “Trigger” button.

4. Select Google Sheets as the trigger app

5. Select a trigger: In the “Trigger Event” field, select “Create item”. Also, connect your Webflow account. Then click on “Continue”.

6. Select your Spreadsheet and Worksheet and click “Continue”.

7. Next, you need to test the operation of the trigger by clicking on the “Test trigger” button.

8. Then the system should find and display all the information. Click on “Continue with selected record”.

Adding an action to Google Sheets.

9. Select the action app.

10. Select an action: In the “App” field, select “Webflow”, in “Action Event” select “Create item”. Next, connect your Webflow account. When everything is done, click on “Continue”.

11. Setup the action:

Link Google Sheets data with corresponding rows in Webflow. 

• Connect the “Site” field on Google Sheets to the same field on Webflow.

• Connect the “Collection” field on Google Sheets to the collection name on Webflow.

• Connect the “Price” field on Google Sheets to the same field on Webflow.

• Connect the “Description” field on Google Sheets to the same field on Webflow.

• Connect the “Image URL” field on Google Sheets to the same field on Webflow.

• Connect the “Product name” field on Google Sheets to the same field on Webflow.

• Set “Archived” and “Draft” values to False.

After you’re done, click ”Continue”.

12. Testing the integration.

• Test & Continue: Click on  “Test Step” to check if the is transmitting correctly between Webflow and Google Sheets.

13. If everything is correct, click “Publish” to publish a new category to Webflow from the data on Google Sheets.

14. Check your Webflow and make sure that the data is correct.

15. If the test is successful, click “Transfer existing data” to transfer the remaining data to Webflow.