Round Robin with Google Sheet "Row Index" Problem

[toplinedropship]

Hi guys,
I am trying to set up Round Robin with Pabbly Connect from Elementor Forms to Google Sheets. The last video update on this topic was 3 years ago and has not been updated since the Google Sheet in the Pabbly Connect platform has some new updates.

This video explains my challenge better - https://www.loom.com/share/5839949ec53c45e18122f18fee93aa8e?sid=511e2c89-1c7b-4c3d-b061-fab7736aaf2d

Can anyone please help advise me better?

Anyone with urgent solution please help

 

[Deleted member 15445]

Hey @toplinedropship

We've reviewed your workflow and need clarification on a few points:

• Please confirm whether you intend to send every form entry to alternate sheets or if you plan to use the same sheet, but alternate rows.
• Additionally, if you wish to start entries from number 5 in both sheets, you'll need an additional "counter" within each router before the Google Sheets step. Please confirm this requirement.
• Lastly, ensure your webhook is properly set up in Elementor, as no responses have been captured since the initial one.

Please confirm these details so we can assist you effectively.

 

[toplinedropship]

Thank you for your help,

1. I would like to send every form entry to alternate spreadsheets as seen in "Order Sheet [NG] - Godswill...] and "Order Sheet [NG] - Chiemeka..."
2. I didn't try adding an additional counter. Maybe I should try that?
3. Webhook is well set up and verified working. I know how to set up webhook

 

[Deleted member 15445]

Hey @toplinedropship

Thanks for the prompt response.

We have made a few changes in your first counter so that every form entry registers in alternate Google Sheet.

This Counter will give responses "1" and "0", respectively for both the routes.

Now, before Google Sheets step in both the routes, you need to set up another "counter" same as the one you set up initially.

You need to set up the same "Counter" and map the response Google Sheets.

Let us know if you get stuck at any step or encounter any errors.

 

[toplinedropship]

Its WORKING NOWWWWWW!
Thank you!