Google spreadsheets (PM)

Table of contents

This article describes the Google spreadsheets settings in the program. Connection instructions can be found here - Configuring Google spreadsheets Connection

To start using Google spreadsheets in ZennoPoster, follow these steps.

Specify path to Google OAuth key

Here you need to select the path to the file with the settings for connecting to the Google API.

You can read how to get the OAuth key and set up the connection in the article Configuring Google spreadsheets Connection

The file must have the extension .json

Timeout for clearing up unused Google Spreadsheets

If no project in ZennoPoster uses a Google spreadsheet for the number of minutes specified in this setting, then such a table will be unloaded from memory to save computer resources.

A long timeout can be useful when there is a pause between the run of a specific project working with a Google spreadsheet (for example, on a schedule, every hour). Then there will be no need to download the spreadsheet from the cloud every time.
A small timeout can be useful, for example, if each execution of a project generates a report on the work in a new spreadsheets and there is no need to store spreadsheets in memory after unloading data.

Timeout loading spreadsheet from cloud

Time allotted for loading the table from the cloud.

If the spreadsheet is very large, then synchronization can take a long time and without changing this setting, a download error will occur, because the request took too long.

Policy for handling spreadsheets changes

In this setting you can choose whether ZennoPoster should download third-party spreadsheets changes while working with it.

If the spreadsheet is large, then it can take a long time to load. If you select the Never load third-party changes during operation mode, the program will only send data, without trying to compare local data and data in the cloud, in other words, the program will not waste time and computer resources on this.

Disabling synchronization can be useful, for example, when parsing data, when you do not need the actual data in the spreadsheets.

Useful links: