With Airtable, you can connect your Airtable bases directly to Google Sheets using Sheetgo’s API Connector to automatically import records from any table into a spreadsheet. This automation allows you to set up live dashboards, combine data across bases, and perform advanced reporting without manual CSV exports, empowering you to streamline workflows, centralise insights, and act on data faster.
Prerequisites
- An Airtable account and a base with the table you wish to export.
- The Base ID and Table Name (which you can find via your Airtable API documentation).
- A valid Personal Access Token (PAT) for Airtable authentication. (https://support.airtable.com/v1/docs/creating-personal-access-tokens)
- Access to the Airtable Web API documentation: https://airtable.com/developers/web/api/introduction
- A Sheetgo account authorised to access Google Sheets.
Step 1: Identify the Required API Endpoint
In the Airtable API documentation (linked above), navigate to the section for your specific base. The endpoint format is https://api.airtable.com/v0/{baseId}/{tableName}. Refer to your base’s unique documentation for field definitions and example requests.
Step 2: Generate API Credentials
In your Airtable account, go to the Developer Hub and create or locate a Personal Access Token (PAT) with the necessary scopes (e.g., data.records:read for reading records). Note that Airtable legacy API Keys are deprecated.
Step 3: Open the Sheetgo API Connector
Log in to Sheetgo and open an existing workflow or create a new one. Click on Connect and choose API Request under Data Source. Then select HTTP Request as the method type. You’ll be prompted to enter the API URL and configure authentication and headers.
Step 4: Configure the API Request in Sheetgo
Within Sheetgo, create a new workflow and select HTTP Request as your data source. Use the endpoint URL you identified. Then enter the following header JSON structure:
{
"Authorization": "Bearer YOUR_PERSONAL_ACCESS_TOKEN",
"Content-Type": "application/json",
"@pagination": {
"type": "offset",
"offset_param": "offset"
}
}This configuration ensures Sheetgo uses Airtable’s offset‑based pagination as described in their docs.
Step 5: Choose the Destination Spreadsheet
Pick an existing Google Sheet or create a new one where you want the Airtable data to land. Configure how the data maps into the sheet (headers, columns) and decide whether to overwrite, append or update rows.
Step 6: Execute the Sheetgo Connection
Run the workflow to import the Airtable data into your spreadsheet. Once successful, set up an automated schedule (e.g., hourly, daily) within Sheetgo so your Google Sheet remains up‑to‑date with your Airtable table.