Google Drive

Google Drive is a cloud storage service where you can store files like Google Sheets, Excel spreadsheets (.xlsx, .xlsm), and CSV files. With Coupler.io, you can pull data from these files in Google Drive directly into your destination—no need to manually download and re-upload.

Why connect Google Drive to Coupler.io?

• Replace IMPORTRANGE limitations — Use Coupler.io as a more reliable alternative to Google Sheets' IMPORTRANGE function for pulling data between spreadsheets.

• Consolidate multiple files — Import data from multiple Google Sheets, Excel files, or CSVs in one data flow, then use transformations like Append or Join to combine them.

• Automate data updates — Schedule regular refreshes so your destination file always has the latest data without manual copying.

• Support for multiple formats — Pull data from Google Sheets, .xlsx, .xlsm, and .csv files all from the same source.

Prerequisites

• A Google account with access to the files you want to import

• Files stored in Google Drive (Google Sheets, Excel, or CSV format)

• A destination in Coupler.io (Google Sheets, Excel, BigQuery, Looker Studio, or AI destinations like Claude or ChatGPT)

Quick start

Before you start: Make sure the Google Drive file you want to import is shared with (or owned by) the Google account you'll use to authenticate Coupler.io. If the file is in a shared drive, ensure your account has access to it.

1

Connect your Google account. Click "Connect source" and select Google Drive. You'll be taken through Google's sign-in flow. Approve access to your Google Drive files.

2

Select your file. Paste the spreadsheet URL or ID of the file you want to import. You can also use the file picker to search for it by name. If you're importing from a specific sheet or tab within a spreadsheet, copy the URL of that sheet (the URL will include the sheet ID in the fragment).

3

Choose sheet(s) and range (optional). If your file has multiple sheets, enter the sheet titles you want to import—one per line. You can also specify a cell range (like A1:Z100) to import only part of the sheet. Leave these blank to import the entire first sheet.

4

Select your destination. Pick where you want the data to go: Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination like Claude or ChatGPT.

5

Run the data flow. Click "Run" to test the import. Once it completes successfully, your data is ready in the destination.

Supported file formats

Format	Support	Notes
Google Sheets	✅ Yes	Native format; recommended for best compatibility
.xlsx	✅ Yes	Excel spreadsheets
.xlsm	✅ Yes	Excel with macros
.csv	✅ Yes	CSV files; must be shared or in a folder you can access
.xml	❌ No	Not supported
Charts/Graphs	❌ No	Only table data transfers; graphs must be recreated manually

Google Drive data overview

Google Drive doesn't have predefined entities or metrics like an API-based source. Instead, you import raw table data from files you select. The structure of your imported data depends entirely on what's in your source file.

What you can import

When you connect a Google Drive file, you're pulling table data from it:

• All columns and rows from a sheet (or a specific range you define)

• Multiple sheets from one spreadsheet (consolidate them with Append)

• Data types like text, numbers, dates, and percentages (note: some formatting like percentages may convert to decimal values)

Common import scenarios

Consolidating data from multiple sheets

If your source spreadsheet has separate tabs for each region, product line, or time period, you can import all of them in one data flow using the "Sheet(s)" parameter. List each sheet name on a separate line, and use the Append transformation to combine them into a single table in your destination.

Importing a specific range

If your sheet has headers, notes, or blank rows you want to skip, use the "Range" parameter (e.g., A1:Z100) to import only the data you need. This is faster and cleaner than importing everything and filtering later.

Replacing IMPORTRANGE

Instead of using Google Sheets' =IMPORTRANGE() function, set up a Google Drive data flow to pull data from another spreadsheet. You get better reliability, easier scheduling, and the ability to transform data before it lands in your sheet.

Use cases by role

Marketers

Pull campaign performance data from shared Google Sheets or Excel reports into a consolidated dashboard in Google Sheets or Looker Studio. Combine data from multiple sources (e.g., different ad platforms exported as CSV to Drive) and refresh automatically each morning.

Finance teams

Consolidate monthly reports from different departments or regional managers stored in Google Drive into a master Finance sheet. Use transformations to aggregate data by category, then send summaries to Claude or ChatGPT for analysis and insights.

Sales ops

Import deal pipelines, forecast data, or customer lists from shared Excel files into your CRM or analytics tool. Combine multiple regional files using Append, then use Join to enrich with customer details from another source.

Data analysts

Pull raw data from stakeholder-maintained Google Sheets or uploaded CSVs directly into BigQuery for analysis. Automate the pipeline so your models always work with fresh data, without manual downloading or version management.

Platform-specific notes

• File IDs vs. names: Coupler.io imports based on the file's unique ID (in the URL), not its name. If you replace a file in Google Drive with a new one, you must update the file URL in your data flow settings.

• Encoding: Text in CSV and Excel files must be UTF-8 encoded to import correctly. Files with non-standard encodings may show corrupted text.

• Empty rows: If your source file has blank rows in the middle, they will be imported as empty rows in the destination. Remove them from the source or use a range that skips them.

• Shared drives: Files in Google Shared Drives are supported, but your account must have access to the shared drive.

• Large files: Imports can take longer for files with many rows (1000+) or columns. Use a specific range or sheet to speed things up.

Google Drive common issues

Connection issues

I can't find my file in the file picker

The file picker searches by file name in Google Drive. If you can't find your file:

1. Check permissions: Make sure the file is shared with your Google account or you own it. If it's in a shared drive, verify your account has access.

2. Use the direct URL: Instead of searching, paste the file's full URL or ID directly. Open the file in Google Drive, copy the URL from the address bar, and paste it into the "File" field.

3. Search for shared files: If the file is shared with you but not in "My Drive," it may appear under "Shared with me." Copy its URL directly.

"This importer is using a destination file that is no longer available to the current connection"

This error happens when the destination file's access has been revoked or the authentication token has expired. To fix it:

1. Re-authenticate the destination: Go to your data flow settings, find the destination connection, and re-authorize it.

2. Check file permissions: Make sure the destination file is still shared with your Google account and you have edit access.

3. Verify the file exists: Confirm the destination file hasn't been moved, deleted, or its sharing settings changed.

If you're using Excel as a destination, this error is more common due to Microsoft API changes. Try re-connecting your Microsoft account.

I get "undefined" or "file not found" errors

This usually means Coupler.io can't access the file you specified. Check:

1. File format: Is the file a Google Sheet, .csv, .xlsx, or .xlsm? Other formats (like .xml) are not supported.

2. File is shared: If using a file you don't own, make sure it's explicitly shared with your Google account email.

3. File ID changed: If you replaced the file in Google Drive (even with the same name), its ID changed. Update the URL in your data flow settings.

4. Character encoding: CSV and Excel files must be UTF-8 encoded. Files with other encodings may fail to load.

Missing data

Some rows or columns didn't import

If you specified a range (like A1:Z100), the import only pulls data within that range. Check:

1. Range is correct: Verify the range includes all rows and columns you want. Use A:Z or similar to capture the full extent.

2. Hidden rows/columns: Google Sheets and Excel can hide rows or columns. Unhide them in the source file before importing.

3. Empty rows in the middle: If your data has blank rows, they import as empty rows too. Remove them from the source or expand your range awareness.

4. First row is data, not headers: If you don't have a header row and Coupler.io treats the first row as headers, enable "Skip header" in advanced settings.

The data looks corrupted or has strange characters

Text corruption usually means an encoding mismatch:

1. Check source file encoding: CSV and Excel files should be UTF-8 encoded. If you're exporting from another tool, ensure UTF-8 is selected during export.

2. Re-save the file: Open the source file in Google Sheets or Excel, make a small edit, and save. This can reset encoding.

3. Try a smaller subset: Export a few rows to a new CSV file and try importing that to isolate the issue.

New edits to my source file aren't showing up in the import

Coupler.io imports based on the file's unique ID, not its name. If you:

1. Replaced the file: Even with the same name, a new file gets a new ID. Update the file URL in your data flow settings.

2. Want to auto-update: Schedule your data flow to run automatically (e.g., daily or hourly). The flow will always pull from the same file ID you specified.

3. Are editing the same file: If you're editing the same file and just re-running the flow, changes should appear. Try a manual run to confirm.

If you need to import a different file every day without manually updating the URL, you'll need a workaround like Integromat to rename/move files to a consistent location first.

Permission errors

"Permission denied" or "Access forbidden" error

You don't have access to the file. Check:

1. File is shared: Open the file in Google Drive. Click "Share" and verify your Google account email is listed with at least "Viewer" access.

2. Shared drive access: If the file is in a shared drive, make sure your account is a member of that shared drive.

3. Public link vs. account access: A public link doesn't grant automatic access. The file must be explicitly shared with your account email.

4. Re-authenticate: Disconnect and reconnect your Google account in Coupler.io to refresh your credentials.

Data discrepancies

Row count in source doesn't match import (e.g., 394 rows in source, 377 imported)

This is usually due to empty rows or header/footer content in the source:

1. Check for empty rows: Look for blank rows between data blocks in your source sheet. These count as rows but may look empty.

2. Specify a range: Instead of importing the entire sheet, use a precise range (e.g., A2:Z350) to exclude headers or footers.

3. Use "Skip header": If the first row should not be counted as data, enable the "Skip header" option.

4. Filter before import: Clean up your source file by removing blank rows, then re-run the import.

Percentages or special values convert to decimals (0.5 instead of 50%)

Google Drive imports preserve the raw data value, not the formatting:

1. Formatting in destination: After import, format the column in your destination (Google Sheets, Excel, etc.) as a percentage.

2. Multiple formats in one column: If a column has mixed data types (some percentages, some text), only numeric values will convert. Ensure consistent formatting in the source.

Rate limits

"Quota exceeded" or "Resource has been exhausted" error

You've hit Google Sheets API rate limits. This happens when multiple data flows or imports run at the same time. To fix:

1. Stagger your schedule: Instead of running all data flows at once, spread them out over time (e.g., one at 8am, one at 9am).

2. Run manually one at a time: If you need to run multiple flows now, trigger them individually from the Coupler.io dashboard.

3. Reduce frequency: Lower data flow schedules from every 10 minutes to every hour, if possible.

4. Check external tools: If you use other tools (Zapier, Integromat, etc.) that also access Google Sheets, pause them temporarily to reduce API pressure.

This error is temporary and usually clears within a few minutes. Retry your data flow once the quota resets.

Google Drive FAQ

Can Coupler.io import data from a folder and watch for new files?

No, Coupler.io doesn't support folder monitoring or automatic detection of new files. You must specify a single file URL for each data flow. However, if new files land in a folder daily with the same name, you can use a tool like Integromat to rename/copy them to a consistent location, then point Coupler.io to that location.

Can I import multiple files at once without creating separate data flows?

Not directly—each data flow points to one file. However, you can import multiple sheets from the same spreadsheet in one data flow, and consolidate them with Append. If your files are in different spreadsheets, create one data flow per file and use Join or Append transformations in your destination.

What happens if I update the source file—does Coupler.io automatically pick up the changes?

Yes, if you edit the same source file. When your scheduled data flow runs, it re-imports the current data from that file. However, if you replace the file (even with the same name), Coupler.io will still reference the old file by its ID. You must update the file URL in your data flow settings to point to the new file.

Can I import graphs or charts from Google Sheets?

No, Coupler.io only transfers table data (rows and columns). Charts and graphs must be recreated manually in your destination. You can import the raw data that powers a chart, then recreate the chart in your destination tool.

What file formats are supported?

Coupler.io supports:

• Google Sheets

• .xlsx (Excel)

• .xlsm (Excel with macros)

• .csv (comma-separated values)

Other formats like .xml, .json, .pdf, etc., are not supported.

Why does my CSV file show "undefined" or won't load?

CSV files must be shared with your Google account (just like any other file in Google Drive). If you're importing a CSV that's not explicitly shared with you, Coupler.io can't access it. Also, verify the file is UTF-8 encoded—non-standard encodings can cause load failures.

Can I specify which sheets to import from a spreadsheet with 20+ tabs?

Yes, in the "Sheet(s)" parameter, enter the exact titles of the sheets you want to import, one per line. Coupler.io will import and combine only those sheets (using Append transformation).

How do I import only a portion of my sheet?

Use the "Range" parameter. For example, A1:Z100 imports only columns A through Z and rows 1 through 100. This is useful for skipping headers, footers, or large unused sections.

Why am I getting quota or rate limit errors?

Google Sheets API has rate limits. If you're running multiple data flows at the same time, you'll hit these limits. Spread your data flow schedules across different times—for example, run one at 8:00am, another at 8:15am, etc. Avoid running all of them simultaneously.

Can I send imported data to an AI tool like Claude or ChatGPT?

Yes! After importing data from Google Drive, you can set your destination to Claude, ChatGPT, Cursor, Gemini, Perplexity, or OpenClaw. This lets you analyze or transform the data using AI in the same workflow.

Learn more about available AI destinations in the Coupler.io platform documentation.