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
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.
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.
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.
Create Spreadsheet
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.
Title (required): Define the title for the new spreadsheet.
Headers (optional): Define the names of the columns of the spreadsheet.