Open spreadsheet action in Google Sheets

Use the Open spreadsheet action in the Google Sheets package to open an existing spreadsheet.

Settings

  • In the Username field, enter the same username that you provided in the Connect action.
  • Enter a session name. Use this session name in subsequent actions to associate them with this spreadsheet.
  • Select whether to open the spreadsheet by name, URL, or spreadsheet ID:
    • Name: Enter the file name.
    • URL: Enter the entire URL.
    • Spreadsheet ID: The ID is the value in the URL after the last forward slash. For example, if the URL is https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9, the ID is 12dlAwvrEA4JeLysfFky9.
  • If the spreadsheet contains multiple sheets, select the Specific sheet name option and enter the sheet name.