I created a Zap that is correctly entering the data from an email attachment into the right columns, but it is not creating new rows. It adds all the data that is in that column into one cell without creating a new row.
| Date | Rep ID | Commission | |
| 2021-1,2021-2.2021-3,2021-4 | 1.67,1.88,1.91,1.22 | $10.50,$217.25,$33.61,$22.27 |
Any thoughts on how I can get it to recognize the comma and put it on a new row?
Thanks!
+14Hi
Try using this action: GSheets - Create Row(s)
+14Please post screenshots with how your Zap steps are configured, thanks.
As an alternative, you can try using the Looping app to handle line items:https://zapier.com/apps/looping/integrations
+14Hi
Please post screenshots with how your Zap steps are configured for us to have more context.
Also, please outline a specific example to use.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
