Setup AppiWorks for Google Sheets
What is AppiWorks for Google Sheets?
AppiWorks for Google Sheets is a Google Workspace add-on to interact with any applications from Google Sheets.
Key features of this add-on
queries external apps and presents the data on the Google Sheet by appending or updating the sheet rows.
reads the Google Sheets data and post it to external applications.
How to open AppiWorks for Google Sheets
Open Google Sheets.
In the add-on section of Google Sheets select AppiWorks.
Setting up AppiWorks for Google Sheets
Click on AppiWorks and start the setup.
The first step in creating a new service is creating a new connection. Read Connection settings to learn more on how to set up connection.
Click on Create New Service to create a new service.
Create new Service
Mention the required service name.
Select the required connection.
Select the required entity to perform the action.
Select the required action.
Select the attributes that are needed.
Mention the maximum results required.
Choose the destination tab to save the data.
Click on Execute to execute the service.
Click on Save to save the service.
Click on Cancel to cancel the setup.
Sample Output
