How to save data in Google sheets?

Help Studio
1

I have an excel file with multiple columns, I want to make some changes in that excel file and then save that data into google sheets.
I have seen a video related to this and I have several questions

  • do I need a google account for this?(or it can work just like excel- offline)
  • there is some authentication when saving data into google sheets do I have to automate those steps every time I save data in google sheets?
2

Hey @Sami_Rajput

When you say save data - does that mean you want to upload the sheet to gDrive ?

Thanks
#nK

1 Like
3

Yes, Google Sheets requires a Google account.

Yes you may have to deal with authentication.

Have you looked at the Google Sheets scope activity? It includes a property to tell it what account to use.

1 Like
4

Hi @Sami_Rajput do you want upload the excel sheet to google drive?

1 Like
5

@Nithinkrishna
I have not worked with google sheets before
can i save google sheet offline?

6

@Tapan_Behera1
Actually, the scenario is something like this I have an excel file that requires some changes(like deleting columns) then I want to copy that modified data from that excel file into google sheets and then save that google Sheets online(or if possible offline).

7

Hey @Sami_Rajput

Please directly work with Google sheets online.

Thanks
#nK

1 Like
8

Okay no problem you can follow this steps:

  1. Read and modify the excel sheet and store the data in data table and use the google sheet activity(write range) and write that in the google sheet.
9

Hey, you can follow the steps from this video

-You’ll need to download the package
-Use the google application scope
-Use the find file/folder and output the FileID on the “FeelingLucky” you will look for your google sheet file if you created one manually or you’ll look for the folder that you want to upload your excel file
-Use the write range activity from the Google package or use the upload file

image
image432Ă—560 12.8 KB

-When you run your robot for the first time the google will ask for permissions, just agree
-If you have problems after the first run, configure the scope like this, checking the auth/drive
image

1 Like