Troubleshooting Google Sheet Trigger Issues for Account Management Bot | Lindy Community

Troubleshooting Google Sheet Trigger Issues for Account Management Bot

Hi, I have created a Account management bot which is triggered off a Google Sheet row being updated. At least it was. At some point this afternoon, the trigger seems to have stopped working. I've tried refreshing the page, the connection, turn the flow off and on again, but I can't seem to get the trigger to work. Any idea how to force it to trigger from a Google Sheet again?

👀1

25 comments

Daniel B.
·
·
Additionally, there's some really odd behaviour going on. It's like the flow has reverted to a previous iteration whereby it's triggered by Hubspot, rather than Google sheets. There is no Hubspot trigger or integration within this flow anymore, yet it keeps being triggered by some Hubspot stage update and then gets stuck in loops burning through credits. There is explicitly no reason for this to be happening
Daniel B.
·
·
And to confirm...
Marvin A.
·
·
hey daniel! thanks for flagging!
Marvin A.
·
·
can you please share the task URL so the team can look into this? 🙏🏾
Marvin A.
·
·
How to share your Lindy task URL: 1. Click your Lindy agent → click “tasks” 2. Find the task you need help with 3. Click the specific task (you should see the full execution) 4. Copy that page URL from your browser 5. Paste the URL in your support request Note: The URL should include “task” followed by a number Screenshots are also helpful!
Daniel B.
·
·
Marvin A. is this correct? https://chat.lindy.ai/account-management-bot-6809f6fa7d0992e78cf9cf20/tasks?task=680fdf16aeffd03a362ef72e
👍1
Marvin A.
·
·
Team will investigate!
👍1
Daniel B.
·
·
Thanks
Daniel B.
·
·
Marvin A. the Google sheet trigger stopped working again at some point from Friday onwards and is still not picking up new lines. Any idea how to get this to work?
👀1
Marvin A.
·
·
hmm will let you know asap. team started investigating last Friday but I don’t see a fix yet 👀
👍1
Daniel B.
·
·
Thanks. I've tried changed the trigger to a general Google sheets update, but to no avail. I've now switched it back to a new row added, the specified sheet is connected, I've added new rows, but even running a test, it's not picking up anything
Daniel B.
·
·
Endlessly 'searching'
Marvin A.
·
·
yeah the test modal for this trigger is a bit janky atm (something the team has some planned engineering time for too) —I think the polling frequency is causing wait times for some minutes. But I’d expect the task to be triggered so will have the team investigate more! 🙏🏾
👍1
Marvin A.
·
·
Oh one thing you can actually try (just to unblock you) is to duplicate the sheet and try it with that. for some reason this unblocked another user yesterday
👍1
Daniel B.
·
·
Thanks. It's been polling for >10 mins on the latest updated row, but still hasn't picked up new rows from last week
Daniel B.
·
·
Ok, I'll give that a go, thanks 👍
🙏1
Daniel B.
·
·
Marvin A. that seems to have worked, thanks! It does mean I'll have to update a bunch of other items upstream to join up the process again though
Marvin A.
·
·
Glad it did! Sorry about that! Team is working on finding out why this happened in the first place..
👍1
Daniel B.
·
·
Thanks
Daniel B.
·
·
Marvin A. any news on this? And in particular the credits, I'll need those refunded
Marvin A.
·
·
yeah we couldn’t pinpoint the exact reason for the trigger not firing. while investigating the team came up with a couple drastic improvements though (testing the gsheets trigger works much better now too) + added more visibility into the problem once it happens again.
👍1
Daniel B.
·
·
Sounds positive, thanks for coming back to me
🙌1
Linda
·
·
I am facing the exact problem. My trigger is working in the test mode but not in the live environment.
Marvin A.
·
·
hey Linda can you share the task URL pls? happy to take a look
Marvin A.
·
·
How to share your Lindy task URL: 1. Click your Lindy agent → click “tasks” 2. Find the task you need help with 3. Click the specific task (you should see the full execution) 4. Copy that page URL from your browser 5. Paste the URL in your support request Note: The URL should include “task” followed by a number Screenshots are also helpful!