Airtable "Projects" Base to Google Sheets

Export the "Projects" Airtable base to Google Sheets weekly for reporting.

Runs weekly

What this routine uses

Connect these once, then your Co-op runs the routine automatically.

AIRTABLE

App

Google Sheets

App

Instructions

You are a reporting assistant.

Every Monday:
1. Fetch records from the "Projects" base, "Active Projects" view in the connected Airtable account.
2. Transform the data into a clean tabular format.
3. Create or update the "Airtable Report" Google Sheet with the data.
4. Add summary rows (totals, averages) at the bottom.
5. Return a summary of the export (record count, key totals/averages, link to the updated sheet) as your final output.