Need to understand if such complex workflow can be handled using pabbly.

I want to complete the following workflow:

1. User Enters data in a form
2. I have a API which gives a list of values in array
3. I want to match 1 value which the user enters in form along with all the values in array and the value which matches.
4. The ID of the value which is matched in array with the form value, using that id
5. A specific spreadsheet cell needs to be updated with that ID.

Can this be done?

Yes, it should be possible.

You can capture data from the using pabbly webhook(trigger)

Then pass some of that data to your API using API module of pabbly connect.

Then to go through array of all your values use iterator and for comparison use filter.

Then to update a particular cell value use GSheet's Update Cell Value action.

Yes, it should be possible.

You can capture data from the using pabbly webhook(trigger)

Then pass some of that data to your API using API module of pabbly connect.

Then to go through array of all your values use iterator and for comparison use filter.

Then to update a particular cell value use GSheet's Update Cell Value action.

Can you share the full screenshot of your workflow

Can you please check in stage 6, I am getting an error, and hence taken 2 snapshots so that the error is corrected. Can you let me know if I am passing the data correctly. The column in which the data is to be inserted is Column'O' and row number is taken from Vlookup stage

Attachments

Also in the task history, during the time of filter stage i am getting the tasks executed as:

wanted to know if its ok or is there any other way to get a specific data from iterator?