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…
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.
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?
@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?