Prerequisites

The.comSheets ZapierGoogle Sheets

Intro

Zapier has a feature that allows you to read data from an existing Google Sheet and write it to a The.com Sheet. Please note that this Zapier feature is currently in Beta and may have some issues.

This is a great option for when you want to create an automation from a Google Sheet to a Sheet on The.com but already have data in that Google Sheet. Instead of either coping and pasting data or downloading the data as a .csv and then uploading it to The.com, you can use this Zapier function. 

In order to do this, you'll first need to set up a Zap between a Google Sheet and a The.com Sheet. 

How To

1. Set up the Sheet and the Zap

First, you'll need to set up a Sheet in your site and then create a Zap to update that Sheet when a cell in the Google Sheet has been updated or created.

Note: this article assumes you know the basics of doing this and will skip over some of the details. If you want a better refresher on how to do this, take a look at our reference guide.

To start off, 

1. Create a new Sheet.
2. Enter values in the first row which will serve as the header rows. This step is crucial because without Zapier will not know where to send the data. 
3. Save your Sheet.
4. Open the Zapier integration and follow the prompts (you may not need to sign in if you have already linked your Zapier and The.com accounts). 
   1. Sign in to Zapier.
   2. Connect your Google and The.com accounts.
   3. Select which Google Sheet you want to connect.
   4. Select which The.com site and Sheet you want to connect.
   5. Set up the Triggers and Actions for the Zap. 

As a reminder, the trigger should be either "Create or update" or "Create."

Once you send your test data and turn the Zap on (this may take ~20 seconds to do), refresh your The.com instance to make sure that the data is coming in properly. Then, delete delete the row that was just pulled in so you only have the first (header) row since you first want to import the existing data. Save your Sheet!

2. Transfer Existing Data

This is only doable through the Zapier app, so you'll need to open the Zapier web-app. Find the Zap you just made and rename it to stay organized. 

Click on the dropdown arrow on the right side of your Zap and select Transfer Existing Data.

This will bring you to a page where you will choose which rows form the Google Sheet you want to send into the Sheet.

1. Select all the entries that you want to transfer. 
2. Click "Send data to Zap" and then confirm.

The Zap will run for each row and send that data to your Sheet. Depending on how much data you have to import, this could take a while. Refresh your instance of The.com to see the data in your Sheet!

That's it. Now your Sheet is up to date with the original. Additionally, since your Zap will still be turned on, any updating or new rows will be Zapped to your Sheet!

Known Issues

• The ordering may not match the Google Sheet's order, but will appear in the order they were zapped.