Google Sheet
Google Sheets is a cloud-based spreadsheet software developed by Google . It offers a wide range of features for creating, editing, and collaborating on spreadsheets in real-time.
GSheet Integration
Google Sheets offers various ways to integrate with other services and tools to enhance functionality and automate tasks. Here are some common methods for Google Sheets integration:
Follow these Steps:
Open the Google Sheets
Click on Extensions
Open the App Script and paste the Below Code.
Google Apps Script: Google Apps Script is a JavaScript-based scripting language that allows you to automate tasks and extend Google Workspace (formerly G Suite) applications. You can use Google Apps Script to create custom functions, automate data import/export, and even build custom menu options within Google Sheets. To get started, go to "Extensions" -> "Apps Script" within Google Sheets.
Google Sheets API : The Google Sheets API allows you to programmatically access and modify Google Sheets data. This is more advanced and requires coding skills. You can use the API to read and write data, format cells, and perform various operations on your Google Sheets. Documentation and examples can be found on the Google Sheets API documentation.
Copy this Code and Paste in App Script
Steps 1 : In this you need to Change the Trigger Value in Which Column the Data Ends take that count and enter it as Trigger value.
Step 2 : Copy the Template JSON from WhatsTool **Go to WhatsTool Business > Settings > Templates > Select the Template > Copy the JSON.
Step 3 :** Change The API Key Go to WhatsTool Business > Settings > Developers API > Generate the API Key and Copy that
Step 4 : Kindly Click on Triggers and Change the status as below Image and Save.
Step 5 : Kindly Add new Entry in the Excel Sheet.
Step 6 : Click on Execution to check the Logs of the message Triggered.
Kindly refer the below video for better understanding
Last updated