Skip to main content

Google Spreadsheet

Please read the Material Usage Rules on this site.

🔗 Original page — Source of this material

Creating a Google Spreadsheet​

In ProjectMaker​

You can create a new Google Spreadsheet:

  • From the context menu Add action → Tables → Google Spreadsheet:

image-20200812-191153

image-20200812-191228

The created spreadsheet will be shown in the static blocks panel:

image-20200812-191319

In the cloud​

  • Log into your Google account.
  • Go to your Google Drive and in the upper left corner, select New → Google Sheets → Blank spreadsheet.

image-20210606-073936

  • You can enter any starting data or leave the spreadsheet empty.
  • Wait for the spreadsheet to load, and then copy the URL from your browser's address bar. You will need this when linking the spreadsheet to ProjectMaker.

Spreadsheet Settings​

Attention

Before you start working with Google Sheets, you need to connect them to the program in Settings. You can read how to set up the connection in the article Setting up Google Sheets integration.

image-20211128-132355

Paste the link to the spreadsheet you want to work with into this input field.

Reload Google Spreadsheet​

image-20210508-065322

This button lets you refresh the data in the spreadsheet.

Note

This may be useful if changes have been made not through the program, but from a regular browser or another device.

Google Spreadsheet Preview​

The data from the spreadsheet will be shown in this window.

Attention

Not all spreadsheet data may be displayed here, but only a part of it.

Save changes to the spreadsheet in the cloud​

Should ZennoPoster save any changes it makes to the spreadsheet in the cloud?

First row as headers​

Use the first row of the spreadsheet as column headers

Use atomic row addition​

Enabling this setting can be helpful when several ZennoPoster instances are working with the same spreadsheet simultaneously. You can read more about atomic addition in the article ❗→ Multithreaded work with Google Sheets (Version 7.1.7.0 and above)

Remember frozen rows and columns​

Information

Added in ZennoPoster 7.6.0.0

If your spreadsheet has frozen rows or columns and you want to preserve their frozen state, you need to enable this option. In this case, an additional request will be sent, which will consume ❗→ quotas.

Row separator​

Indicates what will be used as the row separator in the spreadsheet. The separator can be “New line”, “Custom separator” or “Multiple separators”.

Column separator​

Indicates what will be used as the column separator in the spreadsheet. The separator can be the symbol “;”, the “Tab” character, any custom separator, or several separators.

View contents​

Allows you to view the full contents of the entire spreadsheet. In this section, you can also enable the display of control characters, set a filter to search for a specific row or cell, and use the filter constructor.

image-20200812-191835

image-20200812-192002

How Google Sheets Work in the Program​

  • Every time a project starts, the program creates a virtual copy of the Google Spreadsheet.
  • This virtual copy contains all the data from the Google Spreadsheet.
  • While the project is running, the program works with the virtual copy.
  • If Save changes to the spreadsheet in the cloud is checked, the program will periodically write the data from the virtual copy to your actual Google Spreadsheet.
Attention

Important: Data in the Google Spreadsheet doesn't appear instantly; it can take from 10 to 60 seconds.