Update google sheets from GPT

[Avraham_Baba]

Hello there how do i update my Google Sheets with the following scenario
I’m in the travel flight business. so in my Google Sheets, I have already flight from and flight to now I want to update the Google Sheet with the flight time duration from Point A to Point B. I have connected GPT to calculate the date on my Google and did provide me with the flight time.
How do I take the results and update it in Google Sheets Flight From/To is Cell E,F and the flight needs to be showing in Cell G. What app I need to select to retrieve the result and place it Google Sheet Can anyone show me in a vessel the app scenario

[LinkYourTech]

You first need to use a search module to look up all rows that are missing the value on flight time column. Then run the gtp to output the travel time. I suggest you modify the prompt so that you only get the time. Then you only need to map the results of the GTP response into the google sheet by using the google sheet update row module.

Hope this helps!

[abhilash_naik]

You can modify the gpt query to provide you the flight details in a JSON format and then feed it to parse json and send it you desired columns