Google Sheets webhook -> Xero

[Andy Mills]

Hi,

I have a workflow that triggers a webhook from Google Sheets to create an invoice in Xero.

This work absolutely fine when I manually add a row to google sheets!

However what I am actually trying to acheive is for Microsoft Power Automate to add a row to the google sheet, and then a trigger event happens to send the record to Xero.

The record from Power Automate does appear in Google Sheets OK, however the new row event isn't being triggered to send the invoice to Xero.

If i manually run the trigger the invoice is created in Xero.

Is there anything I should be doing to ensure the trigger event gets fired in Google sheets to create the invoice?

 

[Fagun Shah]

Any data added by third party api(not by google forms or manually) will send data to pabbly connect webhook only once per hour. Also you need to check mark both Send on Event & Send on Schedule events in Pabbly Google Sheet Addon setup.

Common Problems with Google Sheets Integration in Pabbly Connect | Pabbly

Check out the solution to the most common problems that you can face in Google Sheets Integration using Pabbly Connect software.

www.pabbly.com