Hi Everyone,
Can you please provides details on how can run Run script on google worksheet, also what are the pre-requisite for this.
Thanks,
Hi @Codeverse
Enable Google Sheets API in Google Cloud and create OAuth or service account credentials.
Connect UiPath using GSuite Application Scope or Integration Service with those credentials.
Run scripts either through built‑in Google Sheets activities or by calling a deployed Google Apps Script via HTTP Request.
For more:
If helpful, mark as solution. Happy automation with UiPath
Those are app scripts that you can create just like macros..a little different in syntax
Below is where you can go on gsheet to create app scripts
integration services needs to be given access to the account which can run app scripts
you can enable triggers for these app scripts like when a value changes in a cell etc..so that we can trigger the scripts this way as well and let them run
cheers
Hi @Codeverse
To run a script on Google Sheets from UiPath, you can use Google Apps Script.
Pre-requisites are: a Google account, access to the target Google Sheet, UiPath Google Workspace activities installed, and proper OAuth authentication set up in UiPath.
Create the script in Google Apps Script (Extensions → Apps Script) and expose it as a function. Then use the Run Script activity from UiPath to call that function and pass parameters if needed.
Hi @Monali_Vekariya,
Thanks for reply, I did setup Google developer account > setup application > enabled API for google sheet. Just wondering if it will work for all Google sheets.
Please let me know if missing anything or could you please help me with some snapshots.
Thanks,
Yes, it will work for any Google Sheet as long as your Google account (or service account) has access and the right scopes are enabled. Make sure OAuth is set up correctly and the sheet is shared with the account you’re using.
Check the official UiPath docs for setup steps: