Xero Accounting to Google Drive

Automatically Export & Sync Xero Accounting Data to Google Drive

Xero Accounting
a black arrow pointing to the right
Google Drive
Conjuntos de datos completos
Sin código
Sin diagramas de flujo complicados
Sin desencadenantes
Se configura en menos de 3 minutos
No se necesitan instrucciones

Conjuntos de datos

Accounts-All
Filterable
Bank Transactions-Alltime
Filterable
Bank Transactions-Last X days
Date Rangable
Filterable
Bank Transfers-Alltime
Bank Transfers-Last X days
Date Rangable
Batch Payments-Alltime
Filterable
Batch Payments-Last X days
Date Rangable
Filterable
Branding Themes
Contacts-Alltime
Filterable
Contacts-Last X days
Date Rangable
Filterable
Contact Groups
Credit Notes-Alltime
Filterable
Credit Notes-Last X days
Date Rangable
Filterable
Credit Notes+LineItems-Alltime
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Credit Notes+LineItems-Last X days
Date Rangable
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Currencies
Employees-Alltime
Filterable
Employees-Last X days
Date Rangable
Filterable
History+Notes by Contact
Filterable
Pre-blended combo set HISTORY-AND-NOTES
History+Notes-AllContacts
Filterable
Pre-blended combo set HISTORY-AND-NOTES
History+Notes-BankTransactions
Pre-blended combo set HISTORY-AND-NOTES
History+Notes-BankTransactions-Last X days
Date Rangable
Pre-blended combo set HISTORY-AND-NOTES
History+Notes-Invoices
Pre-blended combo set HISTORY-AND-NOTES
History+Notes-Invoices-Last X days
Date Rangable
Pre-blended combo set HISTORY-AND-NOTES
Invoices-Alltime
Filterable
Invoices-Last X days
Date Rangable
Filterable
Invoices+LineItems-Alltime
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Invoices+LineItems-Issued-Last X days
Date Rangable
Pre-blended combo set SELF-LEFT-JOINED
Invoices+LineItems-Modified-Last X days
Date Rangable
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Items
Journals-All
Journals by LastModifiedDate
Date Rangable
Filterable
Journals+Lines-All
Pre-blended combo set SELF-LEFT-JOINED
Journals+Lines by LastModifiedDate
Date Rangable
Filterable
Pre-blended combo set SELF-LEFT-JOINED
ManualJournals+Lines-Alltime
Filterable
Pre-blended combo set SELF-LEFT-JOINED
ManualJournals+Lines-Last X days
Date Rangable
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Organisations
Filterable
Overpayments-Alltime
Filterable
Overpayments-Last X days
Date Rangable
Filterable
Payments-Alltime
Filterable
Payments-Last X days
Date Rangable
Filterable
Prepayments-Alltime
Filterable
Prepayments-Last X days
Date Rangable
Filterable
PurchaseOrders+LineItems-Alltime
Filterable
Pre-blended combo set SELF-LEFT-JOINED
PurchaseOrders+LineItems-Last X days
Date Rangable
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Quotes+LineItems-Alltime
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Quotes+LineItems-Last X days
Date Rangable
Filterable
Pre-blended combo set SELF-LEFT-JOINED
RepeatingInvoices
Filterable
Report-1099
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Report-BalanceSheet
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Report-BankSummary by Date
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Report-BankSummary-Last X days
Date Rangable
Pre-blended combo set SELF-LEFT-JOINED
Report-BankSummary-Last 365 days
Date Rangable
Pre-blended combo set SELF-LEFT-JOINED
Report-P+L Standard
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Report-P+L by Date
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Report-P+L-Last365days
Date Rangable
Pre-blended combo set SELF-LEFT-JOINED
Report-P+L-Last90days
Date Rangable
Pre-blended combo set SELF-LEFT-JOINED
Report-TrialBalance at X days Back
Report-TrialBalance MonthEnd at X months Back
Report-TrialBalance at Today
Report-TrialBalance at Yesterday
Report-TrialBalance at LastWeek
Date Rangable
TaxRates
Filterable
Users

Información adicional

This service is designed to help anyone continuously export (i.e. "sync") data from Xero Accounting.

If you only need to export your data one time, check the website of Xero Accounting to see if their service offers a one-time export feature natively. Sometimes a Data Source's native export feature may provide not as much data as its API does, in which case Flatly is the solution.

Additional Information

Flatly uses official API channels to provide an integration with Xero Accounting.
Established in 2006, Xero is a web-based accounting system designed for small and growing businesses.
Employees

Xero offers two different Employees data sets, one from Xero Payroll and one from Xero Accounting. While Flatly supports both, most analysts will find the Employees data set from Xero Payroll more populated and useful.


Nested Items

Flatly offers several key data sets that present Items and Lines on their own unique rows, which makes data analysis of these nested data sets more convenient.

Scopes

Flatly's access to Plaid and Plaid's downstream connected financial institutions is read-only access to text. It is limited to account data (words, numbers, dates). It does not include any money-movement, transfer capabilities or account holder profiles/identities.

Plaid alone interfaces directly with financial institutions, caches data from those institutions on Plaid infrastructure, and then makes the appropriate scoped subset of that data available to partners like Flatly using secure connections called client libraries.

Scopes

Flatly provisions and manages its own App Folder in Google Drive, which contains Google Sheets files, CSV files or XLSX files refreshed by Flatly. Flatly only has access to this one folder. This folder is like an isolated container that you can move anywhere inside your Google Drive, share with members of your team or link to using Google Sheets scripting. Unlike other apps, Flatly does not request overly broad access to all folders, files and sheets in your Google Drive.

Flatly also requests your Google Account email address, to help you keep track of which Google Drive (belonging to which Google Account) you have shared in certain sync jobs in Flatly.

Google Data Studio reads Google Sheets files in Google Drive directly. Google Drive can sync flat files to the desktop automatically.

Formatos de archivo

Google Sheets (Parsed)
Google Sheets (Raw)
XLSX (Parsed)
XLSX (Raw)
CSV File
NDJSON

Integration Flow

Setup

Step 1

Select Xero Accounting from the Data Source dropdown and Google Drive from the Data Destination dropdown.

Step 2

Authorize Xero Accounting with your credentials using the flow.

Step 3

Authorize Google Drive with your credentials using the flow.

Step 4

Select your Data Set from the 64 Data Sets available using the dropdown.

Step 5

Click Flatten to sync your data.

Vídeo tutorial

Fuentes de datos ampliadas

Comience con sus canalizaciones de datos

Conecta tus datos con nuestra solución de integración de datos lista para usar para que puedas concentrarte en administrar tu negocio.