# 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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/airtable-addon/data-overview.md): Airtable field types import into Google Sheets — learn how attachments, lookups, formulas, and linked records appear in your synced data. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/airtable-addon/common-issues.md): Fix Airtable connection errors like null reference errors. Use shareable grid view links instead of base links for successful imports. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/airtable-addon/faq.md): Do you need an Airtable API key for Coupler.io? Answers on shareable links, password protection, formula handling, and sync frequency. - [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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/azure-blob-storage/data-overview.md): Azure Blob Storage data types: CSV, JSONL, Parquet, Excel, and unstructured formats. Learn which file types work best for your use case. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/azure-blob-storage/common-issues.md): Troubleshoot Azure Blob Storage connection failures, missing files, permission errors, and format compatibility issues in Coupler.io. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/azure-blob-storage/faq.md): Common questions about Azure Blob Storage in Coupler.io: authentication, file formats, incremental syncs, and refresh frequency. - [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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/google-big-query/data-overview.md): Write custom SQL queries against BigQuery tables—control your data structure, joins, and transformations completely. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/google-big-query/common-issues.md): Fix BigQuery permission denied errors, service account access issues, and credential problems in Coupler.io. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/google-big-query/faq.md): BigQuery FAQs—use as source and destination, multi-table queries, project references, and data pipeline setup. - [How to get Google Cloud key file?](https://docs.coupler.io/sources/category/files-and-tables/google-big-query/faq/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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/box/data-overview.md): Explore Box data available in Coupler.io — files, folders, users, admin logs, sign requests, events, and collaboration permissions. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/box/common-issues.md): Fix Box connection errors, missing files, permission issues, and data gaps in Coupler.io. API key and User ID troubleshooting guide. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/box/faq.md): Can I export Box admin logs? How does User ID work? Common questions about connecting Box to Coupler.io answered. - [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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/box-data-extract/data-overview.md): Explore Box Data Extract entities: text representations, AI Ask responses, and structured metadata pulled from Box folder documents. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/box-data-extract/common-issues.md): Fix Box Data Extract connection errors, missing files, folder ID mistakes, and AI prompt issues when syncing Box documents via Coupler.io. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/box-data-extract/faq.md): Can Box Data Extract read subfolders? How do AI prompts work? Common questions about pulling Box document data into Coupler.io. - [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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/coda/data-overview.md): Extract Coda rows, docs, pages, tables, categories, and permissions — pull structured workspace data for auditing and dynamic pipeline builds. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/coda/common-issues.md): Fix Coda API key errors, authentication failures, and missing data issues — validate token format and table ID configuration in Coupler.io. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/coda/faq.md): Find your Coda API key, doc ID, and table ID — quick setup steps for connecting Coda tables to Coupler.io data workflows. - [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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/csv/data-overview.md): CSV imports maintain your file's structure—columns become headers, rows populate as data, with optional filtering. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/csv/common-issues.md): Fix CSV access errors: verify public URLs, use shareable Google Drive links, and test in incognito mode. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/csv/faq.md): Import publicly accessible CSVs from any source—Google Drive, servers, APIs—using direct file URLs with Coupler.io. - [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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/dropbox/data-overview.md): Import columns and rows from Dropbox CSV or Excel files. Coupler.io reads your data as-is with headers as column names. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/dropbox/common-issues.md): Fix Dropbox file picker issues, account connection problems, and file permission errors preventing data imports. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/dropbox/faq.md): Can you import multiple Dropbox files? How do file moves affect flows? Get answers on Dropbox data import limits. - [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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/gdrive/data-overview.md): Pull table data, multiple sheets, and custom ranges from Google Drive files. Structure depends on your source file layout and selection. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/gdrive/common-issues.md): Can't find your Google Drive file? Fix permission gaps, use direct URLs, and troubleshoot shared drive access issues with Coupler.io. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/gdrive/faq.md): Import multiple Google Drive files, monitor folders for new data, and automate file selection — answers to common Google Drive setup questions. - [Google Sheets](https://docs.coupler.io/sources/category/files-and-tables/google-sheets.md) - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/google-sheets/data-overview.md) - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/google-sheets/common-issues.md) - [Best Practices](https://docs.coupler.io/sources/category/files-and-tables/google-sheets/best-practices.md) - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/google-sheets/faq.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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/json/data-overview.md): Define JSON API structure with endpoint URL, HTTP method, authentication, and parameters. Map nested data using paths for flexible, API-driven imports. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/json/common-issues.md): Fix JSON connection errors — 401/403 auth failures, rate limits, empty responses, and malformed payloads. Verify credentials and API documentation. - [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/best-practices/how-to-define-the-path-for-selecting-json-objects.md) - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/json/faq.md): Can you connect REST APIs with JSON? Yes — OAuth tokens, API keys, custom endpoints, and microservices all supported. Learn authentication and data extraction. - [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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/microsoft-excel/data-overview.md): Import sheets and cell ranges from Excel workbooks in OneDrive or SharePoint — configure exactly what data flows to your destination. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/microsoft-excel/common-issues.md): Fix Microsoft 365 sign-in errors, OneDrive access issues, and conditional access policy blocks for Coupler.io Excel connections. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/microsoft-excel/faq.md): Connect Excel files from OneDrive or SharePoint, import multiple sheets, and sync data automatically with Coupler.io. - [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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/mysql/data-overview.md): MySQL table exports preserve your schema structure—all rows and columns transfer to sheets, databases, or AI destinations unless filtered. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/mysql/common-issues.md): Fix MySQL connection errors—verify hostname, port, firewall rules, and whitelist Coupler.io IPs to resolve 'connection refused' issues. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/mysql/faq.md): Can't query MySQL directly? Create a view with your custom SQL logic, then export it via Coupler.io for flexible, filtered data. - [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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/onedrive/data-overview.md): Import data from OneDrive Excel files by selecting workbooks, sheets, and ranges — flexible sourcing for any spreadsheet structure. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/onedrive/common-issues.md): Fix OneDrive WAC access token errors, file availability issues, and connectivity problems preventing Excel syncs. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/onedrive/faq.md): OneDrive personal and Business (SharePoint) files work the same — shared files appear automatically once authenticated. - [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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/postgresql/data-overview.md): Import PostgreSQL data via table selection or custom SQL queries. Choose tables, views, or write queries to filter, join, and transform database records. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/postgresql/common-issues.md): Fix PostgreSQL connection errors: firewall rules, IP whitelisting, authentication failures, and AWS RDS security group configuration on Coupler.io. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/postgresql/faq.md): PostgreSQL IP whitelisting, firewall rules for AWS RDS and Azure, authentication setup, and refresh scheduling — quick answers on Coupler.io. - [Redshift](https://docs.coupler.io/sources/category/files-and-tables/redshift.md): Export Redshift tables, views, and SQL queries to Google Sheets, BigQuery, Looker Studio, and AI tools with Coupler.io — no coding needed. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/redshift/data-overview.md): Access any Redshift table, view, or custom SQL query result. Coupler.io exports your data based on schemas and permissions in your cluster. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/redshift/common-issues.md): Fix Redshift connection timeouts and access errors — security group settings, VPC accessibility, and port configuration troubleshooting. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/redshift/faq.md): Can you connect private VPC Redshift clusters? Public endpoints, SSH tunnels, and VPN solutions for Coupler.io Redshift integration. - [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. - [Data Overview](https://docs.coupler.io/sources/category/files-and-tables/tableau/data-overview.md): Access dimensions, measures, and raw data rows from Tableau views — export complete datasets without manual downloads. - [Common Issues](https://docs.coupler.io/sources/category/files-and-tables/tableau/common-issues.md): Fix Tableau authentication errors, permission issues, and sign-in failures when connecting to Coupler.io. - [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. - [FAQ](https://docs.coupler.io/sources/category/files-and-tables/tableau/faq.md): Answers on exporting multi-sheet dashboards, accessing private Tableau Server behind firewalls, and data refresh timing. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.coupler.io/sources/category/files-and-tables.md?ask= ``` The question should be specific, self-contained, and written in natural language. 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.