That worked perfectly. Thank you!! I’m so glad I tried using this forum…
Topic summary
Main issue: When using Shopify Flow to add a review as a new row in Google Sheets, commas in customer review text were treated as delimiters, breaking the row into extra columns.
Key proposals:
- Suggestion to run a code step to replace commas or URL-encode the text (declined to avoid altering user input meaning).
- Use Liquid (Shopify’s templating language) to escape commas so they aren’t treated as delimiters.
Solution implemented:
- In the “Add row to spreadsheet” action, use Liquid directly in the row values field to escape commas:
- Example: {{ reviewTitle | replace: ‘,’, ‘,’ }},{{ reviewBody | replace: ‘,’, ‘,’ }}
- Clarification: The Liquid textbox is within the Google Sheets action itself, not a separate step.
Outcome:
- User confirmed the Liquid escape method worked perfectly.
- Screenshots helped identify where to input Liquid in the action field.
Status: Resolved. No remaining open questions; optional paid assistance was offered but not needed.
1 Like