Klips Tips: Importing data from Google Sheets

Having issues importing Google Drive Sheet data into Klipfolio? This article includes some helpful troubleshooting tips and suggestions.

Emoji format

Ensure all emojis are encoded in UTF-8.

Importing data from large or complex Google Sheet files

Google Drive has a limit of 10MB per file export, which means files of this size (or larger) can’t be imported into Klipfolio. Google Sheets files with complex and slow-loading formula structures may also return errors when exporting from Google Drive.

Only a subset of data from a large Sheets file is usually needed when working in Klips. However, if there are formulas or calculations being performed in the main sheet, it can be difficult to copy and paste data into a smaller sheet. Using the IMPORTRANGE function enables you to reduce your file size and simplify data that includes multiple sheets, functions, and complex formulas, all without compromising the Sheet’s original data.

Follow the steps below to use the IMPORTRANGE formula in Google Sheets to import only the necessary data into Klipfolio, without breaking any existing formulas or data relationships in your main spreadsheet.

  1. Create a new Google Sheets file.
  2. In a cell in the new file, insert the IMPORTRANGE formula using the following arguments:
  • First, the full URL of the Sheet you would like to pull data from.
  • Second, the cell reference to that sheet for the relevant data (ie “Sheet1!A:Z”).

This will return an exact copy of the data in your original spreadsheet and will automatically update as new changes are made to your original spreadsheet. 

Have more questions? Submit a request