Streaming live at 10am (PST)

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

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

  3. In the API Connector dashboard, copy 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:

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


1 Like