Google Sheets Shared Drive

[Crlnt]

Hello,

I am trying to connect a Google Sheet from a Shared Drive but the drive and sheet are not being fetched. Can you help me with this? Thank you.

 

[Supreme]

Hey @Caryl

Can you please share the workflow URL in which you are using the same Google Sheets?

So that we can look into it.

 

[Crlnt]

Hello, here you go: https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZjMDYzNTA0Mzc1MjZhNTUzNDUxMzAi_pc

 

[Supreme]

Could you please share a screenshot from your Google Drive displaying the number of drives you currently have?

 

[Crlnt]

I have 3 shared drives.

 

[Supreme]

Hey @Caryl

Can you please try the following Google Drive API directly to check whether the Shared Drive is getting a list from their end or not?

Method: drives.list | Google Drive | Google for Developers

developers.google.com

 

[Crlnt]

Hello, yes all my drives are showing up on the list.

Actually, I have another workflow with a Google Sheet and it's working. The Google sheet is the first step. But when you need to update the Google sheet (Add new row) like the one above, it's not capturing it.

 

[Supreme]

Kindly allow us some time, we are currently looking into it.

 

[Crlnt]

Hello. This has not been solved yet. It's still not fetching the google sheets.

 

[Supreme]

Sorry for the delay, we are currently looking into it. Shall notify you soon.

 

[Supreme]

Hey @Caryl

Can you please make a new connection and then try again? Our technical team has made a small adjustment.

 

[Crlnt]

Hello. I'm trying to do this again but it's not fetching anything.

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[Supreme]

We have forwarded your concern to the team and shall notify you with an update soon.

 

[Crlnt]

Following up on this. Thank you.

 

[Supreme]

Our technical team has thoroughly reviewed all the parameters and conducted tests on our end, which have yielded successful results.

However, it's possible that there may be permission issues or access problems with the Google account you're using when trying to access the sheets from Google Drive.