> For the complete documentation index, see [llms.txt](https://docs.coupler.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coupler.io/sources/category/files-and-tables.md).

# Files & Tables

- [Airtable](https://docs.coupler.io/sources/category/files-and-tables/airtable-addon.md): Connect Airtable bases to Google Sheets with Coupler.io. Automate data syncs, combine tables for reporting, and eliminate manual copying from your database.
- [Airtable Best Practices](https://docs.coupler.io/sources/category/files-and-tables/airtable-addon/best-practices.md): Airtable sync best practices — create view-specific flows, use dedicated import sheets, and manage refresh schedules for reliable data.
- [Azure Blob Storage](https://docs.coupler.io/sources/category/files-and-tables/azure-blob-storage.md): Connect Azure Blob Storage to Coupler.io to sync CSV, JSON, Parquet, and Excel files into Google Sheets, BigQuery, or other destinations.
- [Azure Blob Storage Best Practices](https://docs.coupler.io/sources/category/files-and-tables/azure-blob-storage/best-practices.md): Optimize Azure Blob Storage syncs: manage file paths with glob patterns, choose the right format, and schedule refreshes efficiently.
- [BigQuery](https://docs.coupler.io/sources/category/files-and-tables/google-big-query.md): Query BigQuery datasets with custom SQL and auto-sync results to Google Sheets, Excel, or AI tools via Coupler.io.
- [BigQuery Source Best Practices](https://docs.coupler.io/sources/category/files-and-tables/google-big-query/best-practices.md): Secure BigQuery connections with dedicated service accounts, minimal IAM roles, and query optimization strategies.
- [How to get Google Cloud key file?](https://docs.coupler.io/sources/category/files-and-tables/google-big-query/how-to-get-google-cloud-key-file.md): Learn how to generate a Google Cloud JSON key file to use for connecting Coupler.io to your BigQuery source or destination.
- [Box](https://docs.coupler.io/sources/category/files-and-tables/box.md): Connect Box to Google Sheets, BigQuery, or AI tools via Coupler.io. Export files, users, admin logs, sign requests, and more.
- [Box Best Practices](https://docs.coupler.io/sources/category/files-and-tables/box/best-practices.md): Get the most from Box data in Coupler.io — tips for admin log exports, collaboration audits, and sign request tracking.
- [Box Data Extract](https://docs.coupler.io/sources/category/files-and-tables/box-data-extract.md): Connect Box folders to Google Sheets, BigQuery, or AI tools via Coupler.io. Extract text, metadata, and AI-generated insights from your Box documents.
- [Box Data Extract Best Practices](https://docs.coupler.io/sources/category/files-and-tables/box-data-extract/best-practices.md): Get the most from Box Data Extract — folder structure tips, AI prompt design, and how to combine entities for richer document pipelines.
- [Coda](https://docs.coupler.io/sources/category/files-and-tables/coda.md): Connect Coda docs, tables, and rows to Google Sheets, BigQuery, or your data warehouse via Coupler.io for seamless reporting and automation.
- [Coda Best Practices](https://docs.coupler.io/sources/category/files-and-tables/coda/best-practices.md): Master Coda row exports with correct doc and table IDs — pair structured data pulls with workspace discovery for accurate reporting pipelines.
- [CSV](https://docs.coupler.io/sources/category/files-and-tables/csv.md): Import CSV files from Google Drive, public servers, or APIs into Google Sheets, BigQuery, and AI tools via Coupler.io.
- [CSV Source Best Practices](https://docs.coupler.io/sources/category/files-and-tables/csv/best-practices.md): Test CSV URLs before connecting, use Google Drive shareable links, and validate data structure for smooth imports.
- [Dropbox](https://docs.coupler.io/sources/category/files-and-tables/dropbox.md): Automate CSV and Excel exports from Dropbox to Google Sheets, BigQuery, or AI tools via Coupler.io — no coding needed.
- [Dropbox Best Practices](https://docs.coupler.io/sources/category/files-and-tables/dropbox/best-practices.md): Set up Dropbox syncs efficiently — start with one file, use consistent headers, and append multi-sheet data properly.
- [Google Drive](https://docs.coupler.io/sources/category/files-and-tables/gdrive.md): Import Google Sheets, Excel, and CSV files from Google Drive into your data warehouse. Replace IMPORTRANGE with Coupler.io's reliable file syncing.
- [Google Drive Best Practices](https://docs.coupler.io/sources/category/files-and-tables/gdrive/best-practices.md): Use direct file URLs for consistency, clean source data before importing, and set refresh schedules to keep Google Drive syncs accurate.
- [Google Sheets](https://docs.coupler.io/sources/category/files-and-tables/google-sheets.md)
- [Google Sheets Source Best Practices](https://docs.coupler.io/sources/category/files-and-tables/google-sheets/best-practices.md)
- [JSON](https://docs.coupler.io/sources/category/files-and-tables/json.md): Connect to any REST API with JSON source — pull data from custom endpoints, SaaS platforms, and microservices into Google Sheets or BigQuery via Coupler.io.
- [JSON Source Best Practices](https://docs.coupler.io/sources/category/files-and-tables/json/best-practices.md): Test JSON APIs in Postman first, extract nested data with path notation, handle pagination and large responses efficiently.
- [How to define the path for selecting JSON objects](https://docs.coupler.io/sources/category/files-and-tables/json/how-to-define-the-path-for-selecting-json-objects.md)
- [Microsoft Excel](https://docs.coupler.io/sources/category/files-and-tables/microsoft-excel.md): Automate Excel data exports to Google Sheets, BigQuery, Looker Studio, and AI tools via Coupler.io — no manual copy-paste needed.
- [Microsoft Excel Best Practices](https://docs.coupler.io/sources/category/files-and-tables/microsoft-excel/best-practices.md): Store Excel files in OneDrive or SharePoint, use Range parameters for large workbooks, and schedule consistent refresh cycles.
- [MySQL](https://docs.coupler.io/sources/category/files-and-tables/mysql.md): Export MySQL tables and views to Google Sheets, BigQuery, Excel, or AI tools—no SQL skills needed. Schedule automatic refreshes with Coupler.io.
- [MySQL Best Practices](https://docs.coupler.io/sources/category/files-and-tables/mysql/best-practices.md): Whitelist Coupler.io IPs before connecting. Use dedicated MySQL users with SELECT-only permissions for secure, reliable data exports.
- [OneDrive](https://docs.coupler.io/sources/category/files-and-tables/onedrive.md): Sync Excel files from OneDrive to Google Sheets, BigQuery, Looker Studio, or AI platforms with Coupler.io automation.
- [OneDrive Best Practices](https://docs.coupler.io/sources/category/files-and-tables/onedrive/best-practices.md): Maintain consistent sheet names, headers in row one, and proper file structure for reliable OneDrive data imports.
- [PostgreSQL](https://docs.coupler.io/sources/category/files-and-tables/postgresql.md): Export PostgreSQL tables, views, and custom SQL queries to Google Sheets, BigQuery, Excel, and AI tools via Coupler.io — automate reporting without code.
- [PostgreSQL Source Best Practices](https://docs.coupler.io/sources/category/files-and-tables/postgresql/best-practices.md): Whitelist Coupler.io IPs in AWS, Azure, and on-premise firewalls early. Create read-only database users, test connections, and schedule incremental refreshes.
- [Redshift](https://docs.coupler.io/sources/category/files-and-tables/redshift.md): Export Redshift tables, views, and SQL queries to Google Sheets, BigQuery, Data Studio, and AI tools with Coupler.io — no coding needed.
- [Redshift Source Best Practices](https://docs.coupler.io/sources/category/files-and-tables/redshift/best-practices.md): Optimize Redshift exports with custom SQL filters, pre-aggregation, and query testing to reduce transfer costs and keep destinations lean.
- [Tableau](https://docs.coupler.io/sources/category/files-and-tables/tableau.md): Export Tableau view data to Google Sheets, BigQuery, Excel, and AI tools via Coupler.io — automate dashboard data pulls on schedule.
- [Tableau Best Practices](https://docs.coupler.io/sources/category/files-and-tables/tableau/best-practices.md): Start with single-sheet Tableau views, verify permissions, and scale exports safely for reliable automated data delivery.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.coupler.io/sources/category/files-and-tables.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
