Flattening business data to Google Drive (or Google Sheets)

Google Drive is a file storage and synchronization service developed by Google. Launched on April 24, 2012, Google Drive allows users to store files on their servers, synchronize files across devices, and share files. In addition to a website, Google Drive offers apps with offline capabilities for Windows and macOS computers, and Android and iOS smartphones and tablets. Google Drive encompasses Google Docs, Sheets and Slides, an office suite that permits collaborative editing of documents, spreadsheets, presentations, drawings, forms, and more. Files created and edited through the office suite are saved in Google Drive.

https://www.google.com/drive/

Google imposes a 10M cell limit on all Google Sheets. So if your Flatly job attempts to create a Sheet over 10M cells, your job will partially fail with a filename tag of _PARTIAL and a "Request too large" error message. Flatly will automatically re-upload your data as a CSV file, tagged in its filename with _COMPLETE.

CSV files are not subject to the 10M cell limit.

Work-arounds: Consider flattening to a plain CSV file into Google Drive. Or consider an alternative Destination like Box or OneDrive (Excel Online).

You can drag your Flatly-created folder in Google Drive wherever you want it and your jobs will continue to sync successfully. This is because Google Drive uses a folder ID and file ID system instead of absolute paths.