How to add new different values (in different columns) in the same row with Google Sheets?

Status
Not open for further replies.

alexco888

Member
Hi!

I hope you are great.

I am using Ecwid (the trigger is: New Order) for the action "Create a Row on Google Sheets".
I want to add the email information, the purchase date and the specified date of attendance (I am selling workshops).
I am able to create a new Row with the email information of the new buyer.
Nevertheless, I am not able to understand how can I add the purchase date + attendees date in the same row IN DIFFERENT COLUMNS.
I was able to do it in different rows, or in the same row BUT in the same column.

Can somebody here help me with that?

Here is an example of my sheet:
Attendees Workshop
email:Purchase Date:Attendance Date:
[email protected]
[email protected]
 

ArshilAhmad

Well-known member
Staff member
Hi @alexco,

Move the headers of 'Purchase Date' and 'Attendance Date' one row up to the next column immediately after the 'Attendees Workshop' column. Then, click on the refresh button in the 'Select Sheet' field, and the other two fields ('Purchase Date' and 'Attendance Date') will also appear. Ensure that the headers are in the topmost rows for them to be visible in the Google Sheets action step
1701303983744.png
 
Status
Not open for further replies.
Top