Gsuite Activity

Help Studio
, ,
1

I have a task to save my mail into a google spreadsheet. For that, I am using Gsuite activity write range. But I am facing few errors. PFA screenshot.

image
image1365×492 37.6 KB

2

Hi,

First, you need to set value at SpreadSheetId property. We can get it using Find Files and Folders activity.
For now, it’s ok Google Spreadsheet property and UpdatedRange property are blank.

Regards,

3

@Yoichi I am using as you said but facing the following error.
image

4

Hi,

All the activities in Gsuite activities package work inside GSuite Application Scope.
So,we need to set GSuite application scope in workflow. Can you check the following document?

Regards,

5

@Yoichi Hi I hope you are doing well. I have followed above document and there was no error but when I run I got this error plz guide me to solve this.

image
image1362×568 30.4 KB

6

Hi,

Probably, SpreeadsheetID in Add New Sheet activity is wrong. For now,can you check it?(How did you get it?)

Regards,

7

@Yoichi
I am using following key as SpreadsheetID you can see in attached SS. If this is not correct can you let me know how can i get right one?

image
image813×702 23.6 KB

8

Hi,

Can you try to use Find Files and Folders activity? It returns SpreadsheetID etc.

Regards,