Quick summary
Coda lets you import data from Google Sheets directly into a Coda doc and configure a recurring sync schedule so your table stays up to date automatically. By setting a refresh interval, you eliminate manual data entry and keep your workspace aligned with your live spreadsheet data.
Steps
- Inside your Coda doc, go to the top-right corner and click Insert.
- Click the search bar and type Google Sheets to find the integration.
- Select Google Sheets from the list under More Tables, then drag it to the main workspace.
- Enter the URL of your spreadsheet, ensure the necessary permissions are granted, then press Enter to proceed.
- Tap Sync Now to fetch the data from your Google Sheet into Coda.
- Select Hourly as the Refresh Interval to automate recurring data imports.
- Tap Table Options to access additional configuration settings.
- Choose your preferred table format and configure the corresponding customization settings.
- Your Google Sheets data is now live in your Coda doc and will refresh automatically on the hourly schedule you set.
