Google Docs by Zapier
About Google Docs by Zapier
Wish you could make Google Docs and Xero talk to each other? With Zapier it's as easy as drag-and-drop, check out Google Docs by Zapier.
Remember if you have questions or need assistance with Google Docs by Zapier, this is not the best place to ask - this forum is for reviews and feedback only.
For general support, check out the Zapier support centre
BUT Zapier can't deal with dd/mm/yy date format! So your spreadsheet line dated 1 August becomes 8 January in Xero. And they can't offer a workaround......response was "'I'm afraid this is a problem we don't have a good solution to right now. We're working on ways to better format dates for you down the line, but for now we don't have a way to adjust the formatting of that date". Very sad - and I know we're not the only country in the world to use dd/mm/yy dates :-)
5 August 1930 option
Forcing this in Google Docs makes the date in Xero correct.