INSTALLING G-ACCON FOR XERO IN YOUR GOOGLE SHEETS
To install G-Accon Add-on for Xero you need to go to Google Drive and navigate to New -> Google Sheets. In a new Google Sheets press on Add-Ons -> Get add-ons…
In a new popup “Add-ons” window on the upper right side type “G-Accon for Xero” and hit “Enter”. Select the below product and click on the “Install” button to install G-Accon Add-on.
You need to click on the “CONTINUE” button and select your google account.
Google will warn you about the permissions that should be granted to G-Accon for XERO product:
1. “See, edit, create, and delete your spreadsheet in Google Drive”. This permission is needed to write data from Xero into Google Sheets.
2. “Connect to an external service”. This permission is required to connect to Xero Public API to get the required data.
3. “Allow this application to run when you are not present”. This permission is required to auto refresh your data.
4. “Display and run third-party web content in prompts and sidebars inside Google applications”. New user-friendly interface has been designed to help users to navigate through Xero data structure such as Accounts, Account Receivables, Account Payables, Invoices, P&L, Balance Sheets, PO, and etc.
Next step is to click on “Allow” and “Done” buttons. At this point G-Accon for Xero has been installed.
Next step is to open Add-on. Open Google Sheets -> Go to Add-ons -> G-Accon for Xero -> Xero Sign In
Connect to your Xero account. Upon pressing “Connect to Xero” button, you will be redirected to xero.com for authorization and Grant access to G-Accon for Xero Add-on.
You should be redirected back to Google Sheets and see page with “You’ve been successfully authenticated with Xero.com.” You can close the tab and start using G-Accon for Xero Add-on.