Skip to main content
Question

Import the whole google sheets to xero invoices

  • March 17, 2022
  • 1 reply
  • 29 views

HI

I have a google sheet that will update on every night and wanted to import all the data into xero invoices ( I do have assigned different invoice number to each row)

May I know how can I import the whole spreadsheet to Xero in once?

Anthony

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Forum|alt.badge.img+14

Hi @Anthony Chu 

Good question.

Try using a specific column to trigger the Zaps using this trigger: GSheets New/Updated Row and make sure to follow it will a Filter step.

NOTE: The column value will need to be unique each time it’s changed.

 

OR here’s a guide how to create a looping Zap with GSheets and webhooks.

NOTE: It’s Task intensive.