What data can I import and how?

One sheet = one data source

If your spreadsheet contains multiple sheets, you can select and import them all at once. Plecto will create one data source per sheet and store it in Data sources.

Field types and format

We look at the first 50 rows of a column to determine their type (text, number, date). If there are different types in one column, we consider it a text field.

What about calculations?

Plecto will import cells with calculations as static numbers. However, we don't support non-deterministic formulas such as NOW() and GOOGLEFINANCE().

Update frequency

Plecto checks for new data every 15 minutes and runs an automatic data import. You can change the update frequency as well as see the import logs in the data source settings.

Automatic data import and deletion

Each time Plecto runs an automatic data import from Google Sheets, it imports the entire spreadsheet. Since we can’t identify what specific data has been changed in the spreadsheet, we have to handle imports this way.

Plecto supports automatic data deletion for this integration. If you delete rows in the spreadsheet, Plecto will delete the corresponding registrations along with the next data import.

Created date

When you create a data source, you have the option to select which column from your sheet should substitute the Created date field in the data source.

If you leave it at None, all registrations will have the same created date and time, which is the time of the last automatic import, and the values will update automatically along with the latest import.

Terms we use in the article:
- automatic data import – the act of automatically pulling data from your Google Sheets into Plecto
- column/field – a column in Google Sheets spreadsheet is called a field in a Plecto data source
- row/registration – one row in a Google Sheets spreadsheet represents one registration in a data source in Plecto
- sheet – refers to a single sheet within a spreadsheet
- spreadsheet – refers to the entire Google Sheets file
- update frequency – how often Plecto checks for data and updates the data source

What do you want to see?