=Webflow

The =Webflow formula allows you to create and edit your live Webflow CMS items.

=Webflow: How-to Video

1. Set Your Webflow API Key

At https://Overfit.AI
In Google Sheet
At https://Overfit.AI

Sign In at Overfit.AI To Update Your Webflow API Key

In Google Sheet

Use the =API_Webflow Formula to Set Webflow API Key

This is an optional alternative method of authenticating your Webflow API Key directly within your Google Sheet.

=API_OpenAI(key)

Example

=API_Webflow("YOUR-WEBFLOW-KEY-HERE")

You can find your Webflow API Key at Webflow.com/Dashboard

(Website Settings > Integrations > API Access > Generate API token)

Your Webflow API key will be stored securely as a Document Property of any Google Sheet you have authenticated with your Overfit.AI API Key. Anyone you allow to access this Google Sheet will be able to access your Webflow CMS and use your Overfit.AI Tasks.

2. Use the =Webflow Formula in Google Sheets To Add and Edit Your Webflow CMS Items

Refer to the official Webflow CMS Documentation for more details.

=Webflow(collection_id, field, item_id, value, archived, draft)

=Webflow Formula Example

=Webflow("112233...","name","445566...","Elon",,true)

I have a collection with the ID of "112233..." and want to save a draft of an update with the "name" field value set to "Elon" for an item with an ID of "445566...".

I did not set a value for the archived variable because I don't want the item to be archived, and the archive variable is false by default.

Variable

Default

Description

collection_id

null

Your Website's CMS Collection ID - required

null = All Collection IDs

field

"id"

Your CMS Field Name

"all" = All fields

item_id

null

Your CMS Item ID

null = All CMS Items

"new"= Create a new CMS Item

value

null

The new value of your CMS Field Name for the selected item

null = No CMS field values will be updated

archived

false

If the item should be archived

(false or true)

draft

false

If the item should be a draft

(false or true)