Woocommerce order note and google sheets

[marketingguglielmi]

Good morning, I have a sheet sheet pre-filled by ContactForm7 this data creates a customer, an order and a set of notes attached to the order, and so far so good

i have three questions and hope you can help me

1) the google sheetsheet does not automatically send the data each time it is sent from CF7
2) I have to insert the html tag <img src="google sheets field"> (but it always gives me an error)
3) I do not associate the order with an already registered customer

my workflow is: orderportale2023
I enclose the screens

 

[Pabblymember11]

Hey

1) the google sheetsheet does not automatically send the data each time it is sent from CF7

You can only use "Send On Event" when setting up Google Sheets if the data is coming from a Google application or if you manually enter it. If the data is coming from a third-party application, however, you may need to choose "Auto Send On Schedule" or "Send on Schedule," which will forward the data in exactly one hour.

Additionally, make sure the data was filled up to your trigger column.

2) I have to insert the html tag <img src="google sheets field"> (but it always gives me an error)

In the action step, you need to pass the single quotes in place of double quotes and after noticing in your image tag you haven't added the closing slash in the tag which is also causing the error.

Though we have corrected it for now and it is working fine.

3) I do not associate the order with an already registered customer

You need to map the customer's Id in the action step to pass the order to its associated order.