Skip to main content

Google Sheets Integration

Help avatar
Written by Help
Updated today

Business plan required. Learn subscription

You can sync Take App orders to Google Sheets by building an app script

Prerequisite: Copy source code Code.gs from Github


How to install Google Sheets integration

Step 1: Navigate to Settings.

Step 2: Select Integrations.

Step 3: Scroll down and click on Google Sheets.

Step 4: Click on How to install.


Step 5: Navigate to GitHub.

Step 6: Copy the raw file code.

Step 7: Open a new sheet and click on Extensions.

Step 8: Click on App Script.

Step 9: Rename the project.

Step 10: Delete all existing text and paste the copied code. Import the API key.

Step 11: Navigate to the Admin menu > Settings > Integration > Google Sheet. Copy the API key.

Step 12: Return to the TakeApp Script. Paste the API key and click Save.

Step 13: Click Deploy.

Step 14: Select New Deployment. Choose the type.

Step 15: Change the type to Web App.

Step 16: Provide a description and click Deploy.

Step 17: Click Authorize access.

Step 18: Click Done. Return to the Antidote spreadsheet and refresh.

Step 19: Click on the Extension again. Click on TakeApp and Import orders.

Step 20: Rename the sheet.

Step 21: Name it as per your preference. For example, "Take App order".

Did this answer your question?