FAQ

Can I import from multiple Dropbox files in one data flow?

Yes, but you'll need to set up separate data flows for each file. However, you can use the Append transformation in Coupler.io to combine data from multiple data flows into a single destination. This is useful when you have data split across different files.

What happens if I move a file in Dropbox after setting up a data flow?

The data flow will break and show a "file is no longer available" error. To fix it, you'll need to update the file selection in your data flow settings to point to the new location. To avoid this, keep your Dropbox file in the same folder after setting up the import.

Can I import Excel formulas?

No, only the calculated values are imported. If your Excel file contains a formula like =SUM(A1:A10), Coupler.io will import the result (e.g., 150) but not the formula itself. If you need formulas in your destination, you'll have to recreate them there.

Can I import images or charts from my Dropbox spreadsheet?

No, Coupler.io only extracts text and numeric cell data. Images, charts, comments, and other embedded objects are not imported. Only the spreadsheet content itself is transferred.

How do I append data from multiple sheets into one table?

When setting up your data flow, select all the sheets you want to combine in the "Sheet(s)" field. Coupler.io will automatically append all data from those sheets into a single table in your destination. Make sure all sheets have the same column headers for best results.

Can I use a custom date range to import only recent data?

Yes, use the "Range" field to specify which rows to import (e.g., A1:Z500). However, if you need to import only rows updated after a certain date, you'll need to filter the data in your Dropbox file first or use a data warehouse like BigQuery and apply filters after import.

What file formats does Coupler.io support?

CSV and Excel files (.xlsx, .xls) are fully supported. Google Sheets exported to Dropbox as a file will also work. PDFs, images, and other file types are not supported.

Do I need a Business plan to import from multiple Dropbox files?

You need multiple data flows (one per file), which is available on all plans. However, the number of "connections" you can create may depend on your plan. Each Dropbox file you want to import from counts as one connection. Check your plan details or contact Coupler.io support to confirm your limits.

Can I automatically sync data between Dropbox and Google Sheets?

Yes. Set up a data flow from Dropbox to Google Sheets, then schedule it to refresh daily, weekly, or at any interval you need. Each time the flow runs, your Google Sheet will be updated with the latest data from your Dropbox file.

What should I do if my data is importing very slowly?

For large files with hundreds of thousands of rows, consider splitting the import into multiple smaller data flows or using a specific range (e.g., A1:M10000) instead of the entire sheet. You can also use BigQuery as your destination, which is optimized for large datasets. Avoid running multiple Dropbox data flows at the same time — stagger them to reduce load.

For more details on what data is available and how to structure multi-sheet imports, see the Data Overview. For connection troubleshooting, check Common Issues.