Google Sheets integration
Status: Closed · Asked by helen on · 0 views
Hi, after my trigger, I'm doing a search for an email address, using the row number I want to update a cell by including the new value and not replace it. eg.
I did this but it just added to the next column

BEFORE
[TABLE]
[TR]
[TD]Name[/TD]
[TD]email[/TD]
[TD]product[/TD]
[TD]price[/TD]
[/TR]
[TR]
[TD]Fake fname 1[/TD]
[TD][email hidden][/TD]
[TD]product 1[/TD]
[TD]100000[/TD]
[/TR]
[TR]
[TD]Fake fname 2[/TD]
[TD][email hidden][/TD]
[TD]product 3[/TD]
[TD]100000[/TD]
[/TR]
[TR]
[TD]Fake fname 3[/TD]
[TD][email hidden][/TD]
[TD]product 1 [/TD]
[TD]100000[/TD]
[/TR]
[TR]
[TD]Fake fname 4[/TD]
[TD][email hidden][/TD]
[TD]product 1[/TD]
[TD]100000[/TD]
[/TR]
[/TABLE]
AFTER
[TABLE]
[TR]
[TD]Name[/TD]
[TD]email[/TD]
[TD]product[/TD]
[TD]price[/TD]
[/TR]
[TR]
[TD]Fake fname 1[/TD]
[TD][email hidden][/TD]
[TD]product 1[/TD]
[TD]100000[/TD]
[/TR]
[TR]
[TD]Fake fname 2[/TD]
[TD][email hidden][/TD]
[TD]product 3[/TD]
[TD]100000[/TD]
[/TR]
[TR]
[TD]Fake fname 3[/TD]
[TD][email hidden][/TD]
[TD]product 1, Product 2[/TD]
[TD]100000[/TD]
[/TR]
[TR]
[TD]Fake fname 4[/TD]
[TD][email hidden][/TD]
[TD]product 1[/TD]
[TD]100000[/TD]
[/TR]
[/TABLE]
Just checked your workflow and it seems you are missing to pass values in double quotes.

You need to pass comma-separated values within double quotes as "product1","Product2".
Please correct your mapping in the Update Row action step.