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
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.
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.
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.
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.
Last updated
Was this helpful?