Google Sheets Integration Via API Connector

Hey Webflow community!

I am an AI/machine learning freelancer and also run tech support for a small startup. I just came across this awesome CMS and am setting up my own little website, so I decided to kill two birds with one stone: integrate it into Google Sheets! Thus, I wanted to share a way to integrate if you ever want to pull in all the Items for a Collection into a sheet, for example.

  1. Get a copy of API Connector https://gsuite.google.com/marketplace/app/api_connector/95804724197

  2. Get your API key from Settings → Integrations → API Access under your desired website

  3. In the API Connector dashboard, copy https://api.webflow.com/collections/:collection_id/items into API URL Path

  4. Under Headers, use the key:value pairs Authorization: Bearer {API_TOKEN_HERE} and Accept-Version: 1.0.0

  5. Make sure you’ve set your sheet and hit run. Your items should all import into Google Sheets.

You can check out my documentation write-up for more details: https://mixedanalytics.com/knowledge-base/import-webflow-data-to-google-sheets/

Hope it’s useful for y’all, cheers!

Doug

1 Like

Hey @masupport, Thanks for sharing this. I am building a similar tool that doesn’t require you to know any API, header, etc. You just log in to your Webflow a/c and start pulling data.

If you would like to use it, I would love to show it to you. Feel free to ping me on vinayak@nowstackit.com