Trigger from Google Sheet

[Ikay]

Hi, My Usecase is this:

1. Trigger from Google to API - https://keepa.com/ (I can do this)
2. The Results of this trigger, I want it sent back to google sheets. - How can I do this?

Thanks

 

[Fagun Shah]

Trigger from Google?

Can you explain in little more detail?, If you want to find and write to a specific row in google sheet you can use LookUp Rows in pabbly connect.

If you explain in detail, it will be more easy to help.

 

[Ikay]

Thanks Fagun, just seeing this now.

Keepa essentially has lots of data on millions of Amazon's product. and it has an API.
my usecase is this.
I have a google sheets , in one column, say Column B, I want to paste ASIN codes (amazon's sku numbers)
In column C to F, I want it to be populated with the Product details from Keepa.

I have been able to query the Keepa API using the API function of Pabbly, Now, I want to pass that results into the Google sheets

Does this make it clearer?
Thanks again

 

[Fagun Shah]

Now, I want to pass that results into the Google sheets - Use "Update Row" action of Google Sheet in Pabbly Connect where you can avoid updating cells/columns you do not want to make any changes.

So you can keep your ASIN codes as itis and update column C to F for that particular ASIN.