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

[Kaushal Didwania]

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?

 

[Fagun Shah]

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.

 

[Kaushal Didwania]

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.

2 followup queries regarding the same exercise.
1. While testing will the filter only use the 1st row value in pabbly workflow
2. How can we get the row number of the cell using update cell value function in pabbly.

 

[Fagun Shah]

Can you share the full screenshot of your workflow?

 

[Kaushal Didwania]

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

 

[Kaushal Didwania]

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?