Best Practices

Recommended setup

Use direct file URLs for consistency

Always paste the full file URL instead of relying on the file picker. This makes it easier to track which file you're importing and reduces confusion if file names are similar. Bookmark the URL in a doc for reference.

Clean your source file before importing

Remove empty rows, extra headers, and trailing data in the source file. This ensures your import is clean and prevents misaligned columns or skipped rows in the destination.

Use specific ranges for large files

If your sheet has 1000+ rows, specify a range (e.g., `A1:Z500`) instead of importing the entire sheet. This speeds up the import and avoids unnecessary blank rows at the end.

Consolidate multiple sheets with Append

If you're importing from multiple sheet tabs, use Coupler.io's Append transformation to combine them into one table instead of creating separate data flows for each sheet.

Data refresh and scheduling

Start with hourly or daily refreshes

Don't schedule more frequent than necessary. Most use cases work well with hourly or daily updates. This reduces API quota stress and keeps your destination file stable.

Stagger schedules if you have multiple flows

If you have 5+ data flows using Google Drive, spread their schedules across different hours. Running all at once can trigger quota limits. Offset each by 10-15 minutes.

Test with a manual run first

Always run your data flow manually once before scheduling. This confirms the setup works and lets you catch errors before they repeat on schedule.

Performance optimization

Limit columns in your range

If your sheet has 50 columns but you only need 20, specify the range as `A1:T1000` instead of `A1:Z1000`. Smaller ranges import faster and use less memory.

Move to BigQuery for very large datasets

If you're importing 100k+ rows regularly, consider BigQuery as a destination instead of Google Sheets. BigQuery handles large datasets much faster and reliably.

Common pitfalls

Don't re-upload the same file with a new name expecting Coupler.io to find it automatically. When you upload a file to Google Drive, even with the same name, it gets a new file ID. Your data flow will still point to the old file. Always update the file URL in your settings if you replace the source file.

Don't try to import XML files or unsupported formats. Coupler.io only supports Google Sheets, .csv, .xlsx, and .xlsm. Attempting to import other formats will result in "file not found" errors.

Do

• Share the source file explicitly with your Google account email

• Use UTF-8 encoding for CSV and Excel files

• Consolidate multiple sources into one data flow using Append or Join

• Schedule different data flows at staggered times

• Test manually before enabling schedules

Don't

• Use public links instead of explicit sharing

• Import files with unknown or non-UTF-8 encodings

• Create a separate data flow for each sheet (use Append instead)

• Run all data flows at the exact same time

• Assume a renamed file will still work (it won't—update the URL)