@walter_rib wrote:
I'm using Peopleapi to access contacts. The contact must be loaded only in the contacts of those who run the script in automation
By "Peopleapi", are you referring to Googles' People API interface? If so, just a quick look and it appears to me that you can call the API with a an account that has administrator privileges and return contact details for several users. Presently People API does not integrate with AppSheet (like Google Calendar does). The integration would need to be built. You will need to study the API documentation to understand how to use it in that way.
Also, do understand that AppSheet Automations do NOT support request/response type calls - i.e. you cannot make automations that calls to an API, waits for response and then receives the payload for processing. Either the Automation sends a set of data to the external API ...OR... the external API sends a set of data into AppSheets' API service - which would be as a series of ADD calls.
The only exception is the ability to call a Google Script and have a few variables returned, but this exception cannot handle multiple rows of data.
If your need to is to send a request and get back multiple rows of data (e.g. rows of contact details) you have two options (I am aware of):
1) Create a Google Script that is executed from the App. The script is responsible for connecting, retrieving the data and populating the data source - whether it is a sheet or a database.
2) Use an integrator service (e.g. Make). These have connectors to multiple different services and integrate communication between different platforms. For example, Make does connect to AppSheet API. If it also connects to People API, then you can create a process that manages the communication between these two and passes the data from People API to AppSheet though the AppSheet API.
I hope this helps!
LinkedIn
Twitter
