Importing CMS items using Zapier

Zapier lets you connect over 750 apps with the Webflow CMS. 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 this Zap 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.

First, pick the app that you want to use for the Trigger (in this case, Google Sheets).

Select the trigger app.

Then pick the Trigger you want to fire.

Choose the trigger.

Next, 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.

Now, pick Webflow for the Action app.

This tells Zapier you are going to make a change in Webflow when the Trigger is set.

Then, 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.

Finally, 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.

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.

Need to know
At the moment, you cannot map CMS reference and multi-reference fields to Zapier fields.
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.