Prerequisites

The.com BasicsGoogle SheetsZapier

Intro

Learn how to connect data from Google Sheets 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 a Google Sheet and a Sheet.

If you already have a Google Sheet filled out, make sure that the columns have header names and then download it as a CSV. Skip to Import a CSV into a Sheet.

In Google Drive

1. Create a new Google Sheet 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.

Your Google Sheet should look something like this:

Creating a New Sheet

1. From the worksheet view of The.com editor, 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 Google Sheet 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 top 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. Note: 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 Google Sheet.

The action will be to write the updated data from the Google Sheet to a Sheet.

Within Zapier, setting up the trigger and 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 Google Sheets 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 the Google account

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

Step 4) Set up a trigger

1. For “Spreadsheet”, select the Google Sheet that you want to send to your Sheet.

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

3. For “Trigger Column”, leave it as “any_column” if you want any column to trigger an update. Otherwise, you can specify which column you want to trigger the Zap.

4. Click Continue

Step 5) Test Trigger

1. Click the Blue Test button.

2. If the test is successful, you will see the last row of data from your spreadsheet. 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 Google Sheet 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 Number field, click “show all options” and then select the “Row ID” option.

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 Google Sheet.

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 Google Sheet.

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, congrats! Any changes in the data from your Google Sheet will be pulled into your Sheet automatically.

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