Prerequisites

The.com BasicsAirtableZapier.

Introduction

Learn how to connect data from Airtable to a Sheet in your The.com Site. This is done through our Zapier integration. Zapier helps users create automated processes between apps.

Set-Up

Before going into Zapier, you need to set up an Airtable Base and The.com Sheet.

If you already have an Airtable Base filled out, all you need to do is download the Base to a CSV file and then skip to the Import a CSV into a Sheet step. This is because Zapier will only pass new data from Airtble, not existing data.

In Airtable

1. Create a new Airtable Base and give it a relevant name.

2. Give header names to the columns you want to include.

3. Fill out one row of data (below the header row) so that Zapier can make sure the data is being passed correctly.

Creating a New Sheet

1. From the worksheet view, create a new Sheet and give it a relevant name.

2. Click to edit the new Sheet.

3. Give the columns a name in the first row for the data you want to include. They do not have to be the same names as the column titles in your Airtable but should be something to help you stay organized.

4. Save your Sheet.

Your Sheet should look something like this:

Continue to Creating the Zap.

Importing the CSV into a Sheet

1. From the worksheet view of The.com editor, click on the “Import CSV” Icon in the Sheet row and select the CSV file downloaded from Google Sheets.

2. Click to edit the new Sheet. The Sheet will have all the data from the original spreadsheet.

3. Save your Sheet.

Your Sheet should look something like this:

Continue to Creating the Zap.

Creating the Zap

You can create a Zap through the Sheet integration or through the Zapier dashboard.

To use the integration, click the Zapier button in the bottom-right corner of the Sheet editor. Follow the steps to log in to your Zapier account and then proceed to create a Zap in this popup. You need to allow cookies for Zapier to authenticate you properly.

Alternatively, log in to your Zapier account and go to your dashboard. You will now be creating your Zap by setting up a Trigger and an Action.

The trigger will be when a new row is added or an existing row is updated in the Airtable.

The Action will be to write the updated data from the Airtable to a Sheet.

Within Zapier, setting up the trigger and the action is broken into a few steps.

Trigger

Step 1) From the dashboard, click the black “Make a zap” button in the top left corner

You'll then be prompted to create a Zap.

Note: the demo above is split up into steps below.

Step 2) Choose an App and Event

1. Search and select Airtable as the app you want to create a Trigger for.

2. For “Trigger Event”, select “New or Updated Spreadsheet Row” from the dropdown.

3. Click Continue.

Step 3) Choose or sign in to your Airtable account

1. Once you have selected an account, click Continue.

Step 4) Set up a trigger

1. For the “Base” field, select the Airtable Base that you want to send to your Sheet.

2. For “Table”, select the worksheet that you want to send to your Sheet. If you only have one Table in your Base, select that option.

3. If you see a section saying “You must have at least one “Last modified Time” type column in your table to use this trigger…” add another column to your Airtable Base of type “Last Modified Time.”

4. For “Which Timestamp Field Should This Zap Use To Check For Updates?”, select “Last Modified”.

5. For “Limit To View”, select whichever view you want the data to be limited to.

6. Click Continue.

Step 5) Test Trigger

1. Click the Blue Test button.

2. If the test is successful, you will see a row of data from your spreadsheet. it might not make sense if your Base has empty rows, but you can change which record to view. If that is the data you want, go to the next step. If not, go back to set up a trigger and reconfigure from which Google Sheet you want to pull the data.

3. Click Continue.

Possible errors

1. Error: “A header row is not present.” To fix this, make sure that all the columns in your Airtable base have header names. Header names are used in Zapier to match data from the original spreadsheet to the Sheet.

2. Error: “Timeout. Try again later.” This happens because when there is a problem with the connection to the server. Try again later.

Action

This demo is split up into steps below.

Step 1) Set Up Action

1. Search and select The.com for the app.

2. For the Action Event field, select “Send to Sheet.”

3. Click continue

Step 2) Choose Account

1. Select or sign in to your The.com account. After selecting an account, it may take a few seconds to authenticate.

2. Click Continue

Step 3) Set Up Action

1. For the Site ID field, select the name of your Site.

2. For the Sheet ID field, select the name of your Sheet.

3. For the Row ID field, click “show all options” and then select the “Record ID” option. Note: make sure you select “Record ID” and not “ID”. If you select “ID,” any cells that are updated in your Airtable will not trigger an update to your Sheet.

4. The fields after the Row ID field will be the column titles from the Sheet. For each one, select the appropriate matching column from the Airtable.

5. Click Continue

Step 4) Test Action

1. Click test and review

2. If the test was successful, you should get a message saying so. Additionally, if you refresh your the.com site and open the Sheet, you will see a row of data sent from the Airtable.

Step 5) Turn on the Zap!

Automatic Deployments with Zapier 

If you would like your site to be deployed whenever Zapier updates a Sheet with new data, you can turn on auto-deployments through the Zapier button on your The.com Sheet.

 

Congrats

That’s it! Any changes in the data from your Airtable will be pulled into your Sheet automatically.

Depending on your Zapier plan, this process could take between 5-15 minutes.