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 Gsuit…

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…

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

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

Gsuite - Google Sheets

Help

jcvsalinas (Julius Cris Salinas) January 25, 2020, 4:29am 4

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.

Topic		Replies	Views
Read from and Write to google sheet Marketplace	3	3345	July 27, 2019
I have Google sheets I want to read and paste data from xlsx Activities excel , activities , studio , question	7	1776	September 16, 2021
How to read data from google drive write to excel sheet? Studio	3	1350	October 13, 2020
Hoe to read the excel or google spread sheet from the google drive? Activities excel , activities , question	11	728	December 26, 2023
Google spreadsheet Academy Feedback studio	18	4807	November 22, 2019

Gsuite - Google Sheets

Related topics