Import data from Airtable to Google Sheets

Import your data from Airtable views to Google Sheets on a set schedule and with no coding required.

The 4 steps to complete the setup

  1. Fill out the Title field
  2. Set up your data source
  3. Set up your data destination
  4. Configure importer's settings

How to set up Airtable importer video

1. Fill out the "Title" field

Name your importer. We recommend you pick a name that will enable easy in-app navigation for you and your team.

2. Set up your data source

2.1. Fill out the "Shared URL" field

Enter the Airtable view share link of your database.

Review this Airtable instruction to get a shared URL or follow these simple steps:

  • Open your Airtable base and pick a table you want to export to Google Sheets.
  • Click on the Share view button on the toolbar and then Create a shareable grid view link as shown on the screenshot below.
  • Copy your private Shared View Link and insert it in the Airtable importer’s Shared URL field

If you have a password-protected view, click Show advanced.

2.2. Fill out the "Protected view password" field

Enter the password to unlock a password-protected view.

3. Set up your data destination

3.1. Connect a Google Account you want to import data to.

Pick an account you want to connect to.

  • Sign in to the chosen account.
  • Review the contents of access rights which you are granting to Coupler.io and press Allow.
  • Confirm your choices.
  • Read the "Close this window" message and close the pop-up.

3.2. Fill out the "Sheet name" field

Name the sheet, which will be receiving data. If the sheet with this name does not exist, Coupler.io will generate a new one for you.

Click Show advanced to set up optional parameters for your data destination.

3.3. Fill out the "Cell address" field

Type in the address of the first cell where the data range will be imported. The default value is A1.

4.Configure importer's settings

4.1. Enable the Automatic data refresh

  • Select Interval
  • Select Days of week
  • Specify Time range

Check out more about Automatic data refresh.

Click Show advanced to set up optional settings for your importer.

4.2. Pick the Import Mode

Follow this link to read more about choosing a data import mode.

4.3. Add the "Last Update" column

If you want to add a column specifying the date of the last data refresh, toggle the Last Update parameter on.

4.4. Save the changes

Click Save to save the parameters or Save & Import to save the parameters and run the initial import right away.

Book a free onboarding call!
For any questions, feel free to email our team at coupler@railsware.com