Importing items using Zapier

Zapier lets you connect over 1000 apps with the Webflow API. This means you can add content to your Webflow CMS from external apps by setting up a connection in Zapier — no coding required.

Note that the example Zap below doesn't publish the content, it just adds it to your CMS Collection for later review and publication. To publish content, you can use the "Create Live item" Webflow action in Zapier.

Let's look at an example of how this works.

In this example, we're going to add a new blog post to our Webflow CMS each time a new row is added to a Google Sheet.

How Zapier works

A connection in Zapier is called a "Zap." Each Zap has two components:

  1. Trigger, which is an event in one app, that then starts...
  2. An Action, which is something Zapier automatically performs in another app

Here's how that works for the following example:

  • Trigger: Each time a new spreadsheet row is added...
  • Action: Zapier will create a new Webflow CMS item

Set up

Create a Collection

Before you start setting things up in Zapier, you need to have a Collection in place on your site. In our example, the blog posts have the following fields:

Make sure you have a Collection in your site first. In our example, our blog posts have a title, a body, and a date.

Once you have a Collection on your site to serve as a "destination" for the content Zapier will be adding, you'll need to create a spreadsheet that you can import.

Create a spreadsheet

Now create a spreadsheet with a structure that mirrors your Collection's. Each new row we add will become a CMS item.

The spreadsheet we'll import content from, which is structured in the same way as the Collection I'm adding to. Each row represents a CMS item.
For some fields, you'll need to check our CMS API documentation for formatting guidance. For example, dates should be formatted like: 2016-10-24T19:41:52.325Z. The first part represents the calendar date, and the second part represents time of day.

Creating a Zap

The Zap we're going to make will add new items to the Blog posts Collection each time a new row is added to our spreadsheet.

  1. Pick the app that you want to use for the Trigger (in this case, Google Sheets)
Select the trigger app.
  1. Pick the Trigger you want to fire
Choose the trigger.
  1. Pick the spreadsheet, worksheet, and trigger column that you want to pull content from
Make sure Zapier is looking at the right place to pull content from.
  1. Pick Webflow for the Action app
This tells Zapier you are going to make a change in Webflow when the Trigger is set.
  1. After you select "Create CMS Item" as the Action, map the fields from the spreadsheet to the fields in your CMS collection.
Map your spreadsheet data to your CMS Collection.
You'll need to set the "Archived" or "Draft" field to continue.
  1. Hit "Create & Continue" to create the Zap and start migrating content
All set!

Once the content migrates, you'll need to refresh the Designer to see the new content in your CMS panel.

Need to know
At the moment, you cannot map CMS reference and multi-reference fields to Zapier fields.
Must know
Currently, any video link sent to the CMS via the API (including Zapier) will not render right away. Instead, you’ll need to open the new Collection item, click into the video field, then click out. From here, you’ll see the video preview load as expected. This limitation is something our team is planning on improving in the future.
If at first you don't succeed...

Try, try again. In general, because use cases for Zapier vary so widely, getting your Zap to work correctly can take some trial and error. But stay patient! Once you get Zapier working for your site, you can do some amazing things.

Troubleshooting

If you're having trouble with your Webflow to Zapier integration, you can troubleshoot your connection settings from the Connected Accounts page in your Zapier dashboard.

You can test, rename, reconnect, or disconnect your existing Webflow account(s). If needed, you can also connect a new Webflow account. Learn all about connecting and removing accounts from Zapier.

If you are having other trouble with Zapier or your Zaps, check out the the Zapier troubleshooting guides. You can also read about common problems and common error messages an how to troubleshoot them.

Zapier integration help is outside the scope of Webflow support, however, if you couldn't resolve your issue, please contact us and we’ll help as much as we can.