It is my table
It is Action to trigger the bot
It is the bot
I have difficulty in terms of webhook, API Call in appsheet.
I want to get temperature data with an API call to
I already have an account and API Key from
In the table in the google sheet, there are columns LatLong, Latitude, Longitude, API Key, API, API Response, Minimum Temperature, Weather Conditions. (Minimum temperature = temperature).
Please look at the third row (3ad261b3 / Yellow colour).
Currently, there are no responses coming to this google sheet. Meanwhile, what I expected was something like line 4 (3ad26dr1).
In the action as a trigger, I made a button to enter the “ID Suhu” with the value: uniqueid()
On the bot, when ID Suhu is updated, It will “Call API” using URL
In Return Value, I enable it. with specific types:
[current].[temp_c] with type “Text”
I realized that something was missing, but I tried asking chatgpt, Gemini, but there was no solution yet.
I realize this is purely due to my ignorance, because I have never used call api.
Please help so that I can use this webhook and can fill in the columns that I have provided.
Thank You