Flattening business data to Google Sheets (Google Drive)
Google Drive is a file storage and synchronization service developed by Google. 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.
Limitations of Google Sheets (Google Drive)
Google imposes a cell limit on all Google Sheets. So if your Flatly job attempts to create a Sheet with too many 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 Google cell limits.
Work-arounds: Consider flattening to a plain CSV file into Google Drive. Or consider an alternative Destination like Box or OneDrive (Excel Online).