Google Sheets Integration
Sync orders to Google Sheets.
How to install?
Copy source code Code.gs in Github.
![](https://storage.crisp.chat/users/helpdesk/website/d5b5a99f52847800/image_1dnz845.png)
This guide provides a step-by-step process of integrating Google Sheets with TakeApp using an API key.
Start with the following steps:
Step 1: Navigate to Settings.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/1293ea2e-efe8-4fd7-8838-7503daed9329.png)
Step 2: Select Integrations.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/e3d63457-7c84-495f-8d2a-f505c373abf7.png)
Step 3: Scroll down and click on Google Sheets.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/0419f0a2-f6d7-4145-a628-8243327e5bf9.png)
Step 4: Click on How to install.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/ef26bf3c-9858-47b5-b93f-bdfe9cc1b2b2.png)
Step 5: Navigate to GitHub.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/08f219c4-89d8-4fd3-9502-154152423400.png)
Step 6: Copy the raw file code.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/4c7dd172-3db4-44e1-a79a-e7ddcda3e6fb.png)
Step 7: Open a new sheet and click on Extensions.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/a8f1edb6-e39e-49bd-8991-8eb084c7600c.png)
Step 8: Click on App Script.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/0ce7213c-fd92-40da-ae6c-d9c12a1c1e4e.png)
Step 9: Rename the project.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/cf4708cd-c999-4295-8f51-fe68de722727.png)
Step 10: Delete all existing text and paste the copied code. Import the API key.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/14c06a2d-0ace-46ef-96b4-bf6f9b58d67b.png)
Step 11: Navigate to the Admin menu > Settings > Integration > Google Sheet. Copy the API key.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/68e63807-733b-4aa5-912e-ec1160384ba3.png)
Step 12: Return to the TakeApp Script. Paste the API key and click Save.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/95319945-dccb-4e15-a86d-4e4c994adfed.png)
Step 13: Click Deploy.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/e154ad47-0488-4726-ade6-f3aad34ee37f.png)
Step 14: Select New Deployment. Choose the type.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/07c2c9ec-aa77-4d0c-934c-368388e8dab1.png)
Step 15: Change the type to Web App.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/cfd4346a-7e5a-4522-b528-ce7d2484e69e.png)
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/fd6e4d4f-9d7a-4510-8db4-bed9996b34bc.png)
Step 16: Provide a description and click Deploy.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/910f8671-43ac-4793-9d27-0810986a6efa.png)
Step 17: Click Authorize access.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/a710ec1d-c15c-4d58-afd4-a60298813ff4.png)
Step 18: Click Done. Return to the Antidote spreadsheet and refresh.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/61247a85-a3b2-4970-a280-49a5e27ccfb6.png)
Step 19: Click on the Extension again. Click on TakeApp and Import orders.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/bca4f1b7-2ee3-4297-82c0-12835b537562.png)
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/b361678d-f0c0-4072-89dc-aeb30845582e.png)
Step 20: Rename the sheet.
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/d1ce1ec5-21e6-454b-b678-dd2b4a6da2ec.png)
Step 21: Name it as per your preference. For example, "Take App order".
![](https://usercontent.clueso.io/a4f51deb-69aa-46ba-9c77-605c1474ead5/7d428734-4e71-40f5-aa13-11773c705934/fa3d852e-6ac4-449d-a946-48131ed2927d/images/277f89b0-f3f9-418a-ac13-37d040e620fa.png)
Updated on: 29/08/2024
Thank you!