Skip to main content

Celonis Product Documentation

Google Sheets (Skills)

Celonis Process Automation enables users to create spreadsheets and add rows in Google Sheets.

Skills Deprecation

From October 2, 2023, Skills with an equivalent Action Flow module won't be available in teams by default. They'll still work in your existing apps, you just can't use them in new ones. We encourage you to use Action Flows going forward. If you can't move to Action Flows right now, or there's a particular Skill that you rely on, contact the support team.

Google Sheets - Overview

Celonis Process Automation enables users to create spreadsheets and add rows in Google Sheets.

Supported Actions

Celonis Process Automation currently supports the following actions for Google Sheets:

Connection

Add a new connection by signing in with Google OR select "Set connection before execution" to allow the user to sign in with their Google Account on the execution page.

Create Spreadsheet Row
  1. Connection (required): Add a new connection by signing in with Google OR select "Set connection before execution" to allow the user to sign in with their Google Account on the execution page.

  2. Spreadsheet (required): If you added a connection in the previous step, you can select a spreadsheet (by either using the Dropdown or switching to the input field). Otherwise, this input will be shown on the execution page.

  3. Worksheet (required): If you added a connection in the previous step, you can select the worksheet in which you would like to add the row (by either using the Dropdown or switching to the input field). Otherwise, this input will be shown on the execution page.

Show this input on Execution Page

Required inputs which are not defined in the Skill settings, will be shown as inputs on the execution page.

30998651.png
Create Spreadsheet
  1. Connection (required): Add a new connection by signing in with Google OR select "Set connection before execution" to allow the user to sign in with their Google Account on the execution page.

  2. Title (required): Define the title for the new spreadsheet.

  3. Headers (optional): Define the names of the columns of the spreadsheet.

30998650.png