The Precisely Automate Studio Google Sheets add-on enables you to run and manage Studio scripts directly from Google Sheets, eliminating the dependency on Microsoft Excel. By integrating Studio with Google Workspace, the add‑on enables you to interact with SAP systems through a familiar, cloud‑based spreadsheet interface. You can access scripts, manage data, and execute transactions seamlessly. This integration improves accessibility, streamlines workflows, enhances collaboration, and supports use cases including automated data entry and real‑time SAP transaction execution.
List of supported features in Automate Studio and Google Sheet add-on are as follows:
Supported features in Automate version 26.0.2:
- Solution migration: Enables controlled export and import of Google Sheets–based solutions across Development, QA, and Production environments.
- Run non-published script: Enables you to open and execute local, non-published Automate script files from the Google Sheets add-on using a browse dialog or the recent scripts list.
- SAP Logon Pad enhancements: Supports credential-based, SNC, and enterprise portal logon types (SPNego, SiteMinder, and browser-based) in the Google Sheets add-on.
- OOB loopback task: During auto-run execution, automatically routes a failed data processing task back to the originator for correction in Google Sheets.
- Revision of data template: Enables you to open and work on a revised version of a Google Sheets data template from Evolve when revision capability is enabled.
- Backup sheet creation: Creates a backup copy of Google Sheet data within the same document before execution when the Backup Data option is selected on the run screen.
- Google Sheet as XLSX attachment: Converts the current Google Sheet to an .xlsx file and attaches it to SAP transactions at runtime during manual or auto-run execution.
- Supporting document as SAP attachment: Collects documents referenced via the Supporting Doc tag in the data template and attaches them to SAP transactions during execution.
- Version control of GS data template: On login, validates the Google Sheets data template version to ensure compatibility with the deployed solution and prevent execution on outdated templates.
- Synchronous macro execution: Supports synchronous macro execution using the SyncCall parameter, causing the host to wait until the macro completes before returning control.
Supported features in Automate version 26.0.1:
- Validate: Checks the data against SAP rules before execution to ensure accuracy.
- Lock and unlock sheet: Locks the Google Spreadsheet while performing operations such as Run, Write Headers, and Validate to prevent user edits during execution and automatically unlock once the operation is completed.
- Open script file: Opens any script file by double-clicking the file name using the Open menu under the File tab.
- Log Column: Writes execution logs directly into the Google Sheet for easy review.
- Lookup Values: Provides predefined static value lists that allow you to select only permitted values during execution to maintain data accuracy.
- Write log as colour: Displays run results using color‑coded indicators to quickly identify errors or status messages.
- Transform Formula: Enables formulas defined in mapped cells to generate transformed or calculated values before the script runs.
- Chain Scripts: Supports sequential execution of multiple Studio scripts using Google Sheets as the data source.
- Cross Chain script: Enables a chained execution flow in which a query script feeds data to a Transaction script to create an end‑to‑end automation sequence.
- Round trip script: Combines a query and a transaction script to extract SAP data, allow updates, and then post the modified data back to SAP in one process.
- NDR: No Data Review workflows processes data automatically without requiring any data review or approval steps before execution completes.
- One‑step: One‑step workflow supports a single review or approval step for the data template before the workflow completes.
- Two‑step: Two‑step workflow supports two sequential review or approval steps for the data template before the workflow completes.
- Macro: Provides an apps script–based automation function that triggers execution of SAP scripts directly from a Google Sheet through custom logic or a button.
- Extended Log: Displays all messages generated during a transaction run, including warnings and informational messages.
- Write headers: Generates column headers in a data sheet when a data file is not available with the script..
- Locale support: The Precisely Automate Google Sheets Add‑on UI supports English, French, German, and Spanish.