Attio to Google Sheets Export Script

This Google Apps Script lets you sync data from Attio directly into Google Sheets - without needing paid tools, connectors, or middleware.

It’s fast, flexible, and designed to be configured entirely in the script. Great for internal dashboards, backups, reporting, or sharing with non-Attio users.

What It Does

Exports records from Attio Objects, Lists, or Workspace Members
Transforms complex nested data into flat, readable headers
Automatically maps and formats:
- Dates and timestamps
- Locations
- Status values
- Multiselect and structured attributes
Writes each dataset to a specified tab in your Google Sheet
Supports batching, pagination, and retries for large workspaces

Benefits

Free – No need to pay for custom ETL integrations
Flexible – Configure what you want to sync, either Lists or Objects or Workspace Users.
Readable – Exports structured, flattened, timestamped data with clean headers
Secure – Uses Google Apps Script's built-in ScriptProperties to store API keys

Setup Instructions

To get access to the script, please reach out via the Contact Us form. We will respond via email with access instructions. From there, please follow these setup instructions:

1. Get Your Attio API Key

Go to the Developer tab in your workspace
Generate a personal access token
In your Apps Script project, go to Project Settings → Script Properties and set the API key as an environment variable named ATTIO_API_KEY

2. Configure Your Sheet

Create a Google Spreadsheet
Get the Spreadsheet ID from the URL and set it in the script:

const SHEET_ID = "your_sheet_id_here";

3. Configure What to Export

In the script, define what Attio data to write into which tab:

const WRITER_OBJECT = [
  {
    target: "objects",
    object_name: "companies",
    sheet_name: "Companies"
  },
  {
    target: "lists",
    object_name: "abc123-list-id",
    sheet_name: "Qualified Leads"
  },
  {
    target: "workspace_members",
    sheet_name: "Team Members"
  }
];

Notes on Configuration

Object Targets

Target	Description
`objects`	Export standard objects (e.g., `companies`, `people`)
`lists`	Export custom lists via their ID
`workspace_members`	Export users on the workspace (no `object_name` needed)

`object_name` Rules

For objects, use the object slug from the URL (e.g., companies, people)
For lists, use the full UUID list ID from the URL
For workspace_members, omit object_name

Date & Time Formatting

All timestamps are standardized using the DATE_FORMAT constant in the script:

const DATE_FORMAT = "yyyy-MM-dd";

You can change this to:

yyyy-MM-dd HH:mm:ss
MM/dd/yyyy
EEE, MMM d, yyyy
yyyyMMdd_HHmmss
or any other Apps Script-compatible format

Output Example

Sheet tabs are named as defined in WRITER_OBJECT, and each row corresponds to one record. Field names are automatically expanded, e.g.:

id	name	created_at	status__title	email__email_address
rec_123	Acme Inc.	2025-01-01	Active	hello@acme.com

Run the Script

From the Apps Script UI:

Open writeRecordsToSheet
Run it manually or set up a time-based trigger

Functions of Note

Function	Purpose
`writeRecordsToSheet()`	Main runner. Iterates through your `WRITER_OBJECT` array
`fetchAndTransformAttioRecords()`	Gets and flattens Attio records
`writeListsAndObjectToSheet()`	Writes records from objects or lists
`writeWorkspaceUserDataToSheet()`	Writes users from your Attio workspace
`formatTimestamp()`	Formats UNIX timestamps using `DATE_FORMAT`

Security

Your API token is stored securely using ScriptProperties. Never hardcode secrets.

Support

This script is provided as-is for free use. For help with customization or professional support, reach out via the Contact Us form.

Attio Export to Google Sheets