Templates Plugins Courses

Google Sheets (service) by Jarrad


#21

@levon

For some reason I keep getting the following error on my API that uses the same Get Dates and Get Numbers calls that has previously worked.

I’m wondering if there is a limit somewhere on how many or how frequent / consecutive calls are made to Sheets?

I’m running the calls in batches of 10 across each set of 60. So 6 API’s x 2 to get the total of 120 fields populated with the results Bubble side.

In the most recent configuration I tried ALL of the calls returned the screenshot error attached.

Do you know what it is? What I can do?

Thanks, R.


#22

@levon

It’s not letting me know what the problem is.

See screenshot showing all the batches returning the same error.

Thanks, R.


#23

@levon just tested one set of 6, and it only successfully ran one of them.

So it seems indiscriminate to me.

Let me know if you can find anything or let me know if you need anything else.

R.


#24

@levon

I think what I need may be beyond the Sheets plugin. All the issues reported above still stand. But even if corrected I think it’s still going to take too long (10 minutes plus) to get the data back into Bubble. On top of that I’m confident time-out issues are going to be a big problem too.

I have a brief drafted as well as the Sheet that does all the necessary calculation formulas for the results I need to get back out to Bubble along with the Workflows I’ve been trying / testing, and the ‘nearly’ complete MVP app. I think it’s enough to detail what I need.

Would you be happy to sign an NDA (can you give me an email so I can send as a Word file or PDF) so I can issue the documents so we can have a discussion about how you might be able to help?

I’m currently in Thailand for a period of time so I’m GMT +7, Bangkok time.

Let me know, thanks Levon.

Best, Richard.


#25

@levon @karel

Hi, levon and or karel, can you come back to me on the error situation I’ve detailed above.

I can’t move on with any resolution. Still getting the same errors.

Please let me know. It’s been around 4 days since my last message and nearly a week since my last message from you

Is anyone looking into it? Thanks in advance.

See screenshot for what I tried this time. Bubble log shows ‘Workflow error - Raw error from Google Sheets - Get Sheet Values (Dates): {’ - no further explanation.

R.


#26

Hi,
Would you agree to add us as collaborators so we can take a closer look at it? [email protected]


#27

Hi, @karel Karel, thanks for coming back to me.

I’m on Personal Plan at the moment so can’t have collaborators.

But I’ve set the app to everyone can edit so you can go in.

If you need to preview and log into an account use

[email protected] for username
TEST for password

Please let me know when you’re going in so I can leave you to it for as long as you need and I can then I can make it private again.

Let me know. Thanks Karel.


#28

@karel is it likely you’ll get a look today? :slight_smile:


#29

Yes definitively. Please allow me a moment.


#30

Of course! And thank you.


#31

@jarrad

Hi Karel / Jarrad, I was looking for Delete Spreadsheet and Copy Spreadsheet in the plugin.

I see I can copy individual sheets from one to another, but it would be great to do a Copy Spreadsheet in one action that includes all it’s sheets automatically?

Likewise the ability to Delete Spreadsheet is a requirement.

Do let me know if these already exist (I can’t find them), or if they are in progress/your pipeline.

Many thanks, Richard.


#32

@jarrad @karel Bump :slight_smile:


#33

Hi Richard,
sorry for making you wait…
I have just added delete file and copy file methods as well as list files so you can get the file id of the spreadsheet that you need to copy or delete because it’s not returned when you create a spreadsheet.
Please update the plugin version to the latest, refresh the editor and give it another try.
Thanks and sorry again for delayed response


#34

Hi @jarrad @levon - I was wondering if you could please help me figure out my 403 error? From what I can tell this is common with the plugin so hopefully there’s a solution you’re already aware of.

I tried what @richardconner suggested on the Bubble thread i.e. allowing access to my email account, but that didn’t work. It is also already the owner of the sheet so not sure why that would be required.

Here’s the error that I’m getting and my app setup




#35

what is the access rights of the spreadsheet that you are trying to access under service account? make sure that either the spreadsheet is created under that service account, or the spreadsheet can be accessed by anyone, or give access from the spreadsheet to your service account
if you tried the latter, which email address exactly you tried to authorize?


#36

Thanks that worked! Didn’t realize that I needed to share the sheet with the iam.gserviceaccount.com user account