Gsuite - Google Sheets

Hello all!

I am new to UI Path and I am hoping to get a high level understanding of how I can accomplish some simple tasks using the Gsuite Integration.

Context: I have an Excel File with multiple tabs that I would like to upload to Google Sheets. I am not sure how to go about this using the Gsuite Integration.

I figure my two options would be to read whats on the excel file then have the bot replicate that on the google sheet.

Or to have the bot just upload the excel file to google sheets every time. I want to avoid this option though because I believe it would create a new sheet every time I ran the bot…

Thank you in advance for you help!

Hi @Nick_Hathoot,

Yes you’re right, its better to read the contents of each tab using read range, then use GSuite’s write range to write the contents to your Google sheets.

Kindly refer to this guide I made to setup your GSuite account:Setting up your Google API Credentials for GSuite API.pdf (1.7 MB)

Let me know if you already successfuly setup your credentials

Hey @jcvsalinas,

The guide you provided is very helpful thank you very much! Quick question though. Is it more beneficial to use the API key or the Service account? Is one more reliable than the other?

Thank you,
Nick

I’m glad I could help @Nick_Hathoot ive been using API key because it’s the simplest one to use. I dont think it differs in reliability.

@jcvsalinas I was able to successfully setup my credentials for GSuite. Do you have additional guides by chance on creating a read and write process from excel to google sheets?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.