Question

Import the whole google sheets to xero invoices

  • 17 March 2022
  • 1 reply
  • 26 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


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

Userlevel 7
Badge +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.