BLOCKS Reference

Block Reference

G Suite

Update spreadsheet

This BLOCK is currently in beta. The beta version will become unusable after the official version is released.

Some functions may not work properly during the beta. We appreciate your feedback regarding bugs or ways to improve MAGELLAN BLOCKS.

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.

To target files that already exist in Google Drive (i.e. not created/saved using G Suite BLOCKS), you must share the files with the email address for your GCP service account. You can view the email address of your GCP service account in the “GCP service account” section of “Board settings”.

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.

Worksheet name Designate the name of the worksheet to be updated.
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 name of 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.

  • Check the box to include the header line in the output.
  • Remove the check to not include the header line in the output.
Grantee type

Select who to share the spreadsheet with.

  • Specific users: Share with users that you specify.
  • Group: Share with a Google group that you specify.
  • Domain: Share with a G Suite domain that you specify.
  • Anyone on the web: Allow anyone access to the item.
Role granted

Select the role to give to those you share the spreadsheet with.

  • Editor: Can edit the spreadsheet.
  • Commenter: Can view and comment on the spreadsheet.
  • Viewer: Can only view the spreadsheet.
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.

  • Specific users: Designate the email address of a user.
  • Group: Designate the email address of a Google group.
Domain When Grantee type is set to Domain, designate a G Suite domain.
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.

  • Check the box to allow others to find the spreadsheet in search.
  • Remove the check to not allow others to find the spreadsheet in search.