How does Qonto x Google Sheets work?

Create financial dashboards and analyze your transactions

Updated over a week ago

Google Sheets is an online spreadsheet app that lets you create and format spreadsheets. Qonto has developed an integration with Google Sheets to automatically send your transactions to your Google Sheets spreadsheet.

How to set up the integration of Google Sheets with Qonto ?

Simply go to the Integrations and Partnerships section in your Qonto app, click on the Google Drive integration and follow these simple steps:

  • Select the Google account you wish to use to sync your transactions

  • Once logged in, authorize Qonto to sync your data in Google Sheets by clicking Continue

  • Select the date from which you would like to begin syncing your transactions; you may select an earlier date or today’s date

  • Click Finish, your integration is ready! 🎉

A Qonto Connect spreadsheet will be created in your root folder, with a tab synchronizing your transactions. You can also access this spreadsheet from “Useful links” in the top right of your screen.

☝️ Good to know : The transactions already associated with your Qonto account will be synchronized immediately once the integration has been configured; any new transaction on your account will be synchronized the next day by 5AM.

What happens if I edit the tab containing the transactions?

Editing the tab Sync. Transactions - Do not edit will break the connection. If you want to modify some of your transaction information, you should create another tab in the spreadsheet and link it to the protected tab.

Need help in using this integration? We’ll guide you step by step to leverage the export of your transactions into Google Sheets thanks to this dedicated article.

How much of my Qonto account data will Google Sheets have access to?

We will not share any of your data with Google Sheets without your express consent, which you may revoke at any time with a few clicks to stop sharing your data.

For further information about Google Sheets, visit their Help center !

Did this answer your question?