Problem With Google Sheet Integration

(Pete) #1

I’ve had my Telegram bot running smoothly for a few weeks. It’s gone reasonably well. Over the last few days I’ve integrated a lot of Google Sheet calls into it so I can log things automatically like “unknown questions”… record newsletter signups etc. These things are still working fine.

However - last night unexpectedly it stopped pulling content out of my the sheet and since then hasn’t been able to answer any questions where the answer comes from the sheet. Has anybody encountered this problem before? Is it something to do with Google blocking the search and retrieve or something?

In the Log I get;

Date
Jan 5, 2017 10:25:26 AM

Task
Choose Random Book

Message
Something unexpected happened with the service.

Input Data:

Spreadsheet
1HalpF-qdNtC34OODpoFLozdIltzIHpdQemOqTDS31wg

Worksheet
https://spreadsheets.google.com/feeds/worksheets/1HalpF-qdNtC34OODpoFLozdIltzIHpdQemOqTDS31wg/private/full/oufka62

Column
gsx:id

Value
20

(Pete) #2

Update - It just came back on again - equally as unexpectedly as it went off for 10 hours.

Does google have a history of limiting these kind of calls to Google Sheets?

Do I have to upgrade my Google Account to make it more stable or something?

(John Jackson) #3

Actually I have another user who is randomly seeing this error - it’s because we couldn’t parse the XML we get back from Google. We have an update ready to roll out which will give much more info in the log about what Google is coming back with.

(Pete) #4

Awesome - thanks John. It’s been a bit better since I tweaked things a bit.

Rather than having the Google Sheets calls for multiple ‘random’ things scattered across different flows, I’ve actually just integrated them all into one flow to contain it a bit. That’s seems (for now) to have kept things a bit pigeon holed.

(Pete) #5

FYI - I have been having A LOT of fun with the Sheets integration… I’ve even managed to set it all up now to do a lot of very rudimentary analytics collection.

Mosts common queries goes into a tab on the sheet with date etc
Unknown queries is also being collected so I have a record of what to train the bot on

It’s become a really powerful way of keeping the bot monitored as well as supplied with content.

Kudos to Flow.xo for integrating it. A stroke of genius!

(John Jackson) #6

Good to hear that. Yes this has been baffling us too.

Sheets is really popular for this purpose.

(John Jackson) #7

I have a question actually, have you authorized Google Sheets many times in Flow XO? This sometimes causes problems?

(John Jackson) #8

If you have authed Google Sheets many times, could you follow these steps and disconnect Flow XO from Sheets (on the Google side): https://support.google.com/accounts/answer/2541991?hl=en

Then reconnect it inside Flow XO and see how you get on?

(Pete) #9

Hmmmm… I guess I have… every-time I have to call the sheet in the flows I use an Auth. Is that what you mean? Should I be doing the Auth just once as a catch-all or something?

(Pete) #10

Bizarrely - when I follow that link & look on my connected accounts, Flow.xo isn’t on the list at all!

(John Jackson) #11

I mean when you add the action, in the Flow XO UI, the first step after selecting Google Sheets is to auth your account. If you click the ‘Accounts’ tab at the top, do you see a lot of separate Google Sheets connections there?

Don’t worry too much, we should be revealing more info about the error soon and that should lead us to the answer.

(Pete) #12

Interesting - I see two… one was the test I did.

sheets.jpg800×498 62 KB