Google Drive
Update spreadsheet
warning Self-Service Plan users (including trial version users) must enable the Google Sheets API. If you intend to use the sharing feature (Grantee type property), you must also enable the Google Drive API. For more information on enabling the Google Sheets and Google Drive APIs, please refer to Enabling Google APIs.
Overview
This BLOCK updates a spreadsheet in Google Drive.
You must set a variable as the new contents for the sheet you will update. The data stored in the variable should be the same format as used with the Create spreadsheet BLOCK. For details, refer to the Create spreadsheet BLOCK reference page.
info_outline To target items that already exist in Google Drive (not created/saved using Google Drive BLOCKS), you must share the items with the email address for your GCP service account. You can view the email address of your GCP service account in the GCP service accounts section of the Flow Designer Settings menu.
Properties
| Property | Explanation |
|---|---|
| BLOCK name | Configure the name displayed on this BLOCK. |
| GCP service account | Select the GCP service account to use with this BLOCK. |
| File name |
Designate the file name of the spreadsheet to be updated. A new spreadsheet will be created if one with this file name does not already exist. You can also enter the URL of the file. You can use the sharing link or the URL from the address bar of the file. Supports variable expansion.
|
| Worksheet name | Designate the name of the worksheet to be updated. Supports variable expansion.
|
| Starting cell (A1 notation) | Designate the starting cell (A1 notation) for writing to the worksheet. The data will be entered from cell A1 if this is left blank. |
| Input variable | Designate the variable that contains the data to write to the spreadsheet. |
| BLOCK memos | Make notes about this BLOCK. |
| Parent folder | Designate the name of the folder that contains the spreadsheet to be updated. Use this property when spreadsheets with the same file name exist in multiple folders and you want to specify which file to update. |
| Output header line |
Select whether or not to output the header line.
|
| Output keys |
Designate specific keys for the data contained in the Input variable. Only data for the specified keys will be output to the spreadsheet. The spreadsheet columns will be ordered in the same order as the keys you designate in this property. Click ＋ to add keys. |
| Grantee type |
Select who to share the spreadsheet with.
|
| Role granted |
Select the role to give to those you share the spreadsheet with.
|
| Email address |
When Grantee type is set to Specific users or Group, designate the email address of those you want to share the spreadsheet with. You can enter multiple emails at once as a comma-separated list (
Supports variable expansion.
|
| Domain | When Grantee type is set to Domain, designate a Google Workspace domain. Supports variable expansion.
|
| Allow file discovery |
When Grantee type is set to Domain or Anyone on the web, designate whether or not to have the spreadsheet appear in search results.
|