Google Sheets

Learn how to connect Engini to Google Sheets.

Using Engini’s Google Sheets activities, you can create spreadsheets, update values, append data, and manage your sheets effortlessly.

To get started with the Google Sheets app, create a free account at Google.com or use your organizational Google Workspace account.

Getting Started with Google Sheets #

Prerequisites #

• A Google Sheets account.

Add a connection to Google Sheets in Engini #

1. Enter your Engini account at https://app.engini.io.
2. Navigate to Connections page by clicking on the Connections on the left sidebar or by clicking here.
3. Click on the Add connection option located at the topbar.

4. Choose Google Sheets option from the available applications.

5. Enter the following details in the “Add Connection” form:

• Connection name
• Field automatically populated post connecting to a Google account include:
  • Refresh Token: A token used to obtain a new access token when the current one expires.

• Click on the “Sign in with Google” button.
• Sign into your Google account.
• Click on the save button to save the connection.

Actions #

Create a Spreadsheet #

This activity creates a new Google Sheets spreadsheet.

1. Title – Enter the title of the new spreadsheet.
2. Fields
   • Sheets[] – Enter an array of sheet objects to define the initial sheets the spreadsheet will contain.

Initialize Sheet Array #

This activity initializes an array of sheet objects to be used when creating a spreadsheet.

Variable name – Enter the name of the variable that will hold the array of sheet objects.

Append to Sheet Array #

This activity adds a new sheet object to an existing sheet array.

1. Variable – Choose the sheet array variable where the new sheet will be appended
2. Fields
   • Index – Set the position where the new sheet will appear in the spreadsheet.
   • Title – Enter the title for the new sheet being appended to the array.

Range Field #

The Range field specifies the cells in the sheet to be updated or added to. The value in this field must be written using A1 notation, which defines the location of cells or ranges within the sheet. This notation combines column letters and row numbers to identify specific cells, ranges, or entire columns/rows.
Examples of A1 notation for the Range field (sheet name: MySheet):

• MySheet!A:A – Refers to all cells in the first column of MySheet.
• MySheet!A1:B2 – Refers to a specific range of cells in MySheet (first two rows and columns).
• MySheet!1:2 – Refers to all cells in the first two rows of MySheet.
• MySheet- Refers to all cells in the sheet named MySheet.

Get a Spreadsheet #

This activity retrieves metadata about a specified spreadsheet in Google Sheets, such as its properties, sheets, and other details.

1. spreadsheetId – Enter the spreadsheet Id to identify which Google Sheets file to retrieve.
2. Fields
   • includeGridData – Choose whether to include the data within the spreadsheet cells (True/False).
   • ranges – Specify one or more ranges of cells to retrieve.

Get Sheet / Cell #

Enter the Spreadsheet ID to identify the Google Sheets file from which to retrieve the sheet or cell.

1. SpreadSheetId – Enter the spreadsheet Id to identify the Google Sheets file.
2. Range – Specify the sheet name and the cell range to retrieve data from.
3. majorDimension – Choose whether to operate on rows or columns of the specified range.
4. valueRenderOption – Select whether to return raw, unformatted data or display values as seen in the spreadsheet.

Add a Sheet #

This activity adds a new sheet to an existing Google Sheets spreadsheet.

1. Spreadsheet Id – Enter the spreadsheet Id where the new sheet will be added.
2. Properties
   • Title – Specify the title for the new sheet you want to add.
   • Index – Set the index where the new sheet will appear within the spreadsheet. (starts from 0).

Add a Row/Column/Cell #

This activity allows you to add a new row, column, or cell to a specified location in a sheet.

1. SpreadsheetId – Enter the spreadsheet Id where the row, column, or cell will be added.
2. Range – Specify the range in the sheet where the new row, column, or cell will be added.
3. Major Dimension – Choose whether the activity will affect rows or columns (Rows/Columns).
4. Values[] – Provide a 2D array (array of arrays) where each inner array represents a row (or column, based on the Major Dimension). These values will be added as new rows, columns, or cells in the specified range. Ensure the array size matches the intended addition to avoid errors.
5. Value Input Option – Choose how the input values should be interpreted. (Raw/User-Entered).
6. Fields
   • Include Values In Response – Set whether the response should include the inserted values.(True/False).
   • Insert Data Option – Specify how the data should be inserted into the existing sheet.(Overwrite/Insert Rows).
   • Response Date Time Render Option – Choose how date and time values should be rendered in the response (Formatted String).
   • Response Value Render Option – Choose how the values in the response should be returned (FORMATTED_VALUE/UNFORMATTED_VALUE/FORMULA).

Update Row/Column/Cell #

This activity updates the content in a specific range of rows, columns, or cells in a Google Sheets spreadsheet.

1. SpreadsheetId – Enter the spreadsheet ID where the rows, columns, or cells will be updated.
2. Range – Specify the range of the sheet where the update will happen.
3. Major Dimension – Choose whether the update will operate on rows or columns.
4. Values[] – Provide a 2D array (array of arrays) where each inner array represents a row (or column, depending on the selected Major Dimension). The data in these arrays will be written to the specified range in the sheet. Ensure the array size matches the range size to avoid errors.
5. ValueInputOption – Define how the input values should be interpreted (Raw/User_Entered).
6. Fields
   • Include Values In Response – Choose whether to include the updated values in the response.
   • Response Date Time Render Option – Choose how date and time values should be displayed in the response (Formatted String).
   • Response Value Render Option – Choose how the values should be returned in the response (FORMATTED_VALUE/UNFORMATTED_VALUE/FORMULA).

Clear Cell/Row/Column/Sheet #

This activity clears the content in a specific range of cells, entire rows, columns, or even the entire sheet in a Google Sheets spreadsheet.

1. SpreadsheetId – Enter the spreadsheet Id where the rows, columns, or cells will be cleared.
2. Range – Enter the specific range of cells, rows, columns, or the entire sheet to clear.

Delete Sheet #

This activity deletes an entire sheet from a Google Sheets spreadsheet.

1. Spreadsheet Id – Enter the spreadsheet Id where the sheet will be deleted.
2. Properties
   • Sheet ID – Enter the sheet Id that will be deleted from the spreadsheet.
     

Delete Row/Column #

This activity deletes entire rows or columns from a Google Sheets spreadsheet.

1. Spreadsheet Id – Enter the spreadsheet Id where the rows or columns will be deleted.
2. Properties
   • Sheet Id – Enter the sheet Id within the spreadsheet where the rows or columns will be deleted.
   • Dimension – Enter whether you want to delete rows or columns (ROWS/COLUMNS).
   • Start Index – Enter the starting index of the row or column range to be deleted (indexing starts from 0).
   • End Index – Enter the ending index of the row or column range to be deleted (the index is excluded from the deletion).

Rename sheet #

This activity allows to rename a specific sheet within a Google Sheets spreadsheet.

1. Spreadsheet Id – Enter the ID of the spreadsheet that contains the sheet you want to rename.
2. Properties
   • Sheet Id – Enter the ID of the sheet that you want to rename.
   • Title – Enter the new name for the sheet.

Copy a Sheet #

This activity copies a sheet from one Google Sheets spreadsheet to another, or within the same spreadsheet.

1. Source spreadSheet ID – Enter the ID of the spreadsheet that contains the sheet you want to copy.
2. Sheet ID – Enter the ID of the sheet you want to copy from the source spreadsheet.
3. Destination Spreadsheet Id – Enter the ID of the spreadsheet where the sheet will be copied.