• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Woocommerce order note and google sheets

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
 

Attachments

  • non-invia-eventi.jpg
    non-invia-eventi.jpg
    454.7 KB · Views: 43
  • errore-pabbly.png
    errore-pabbly.png
    16.4 KB · Views: 57

Supreme

Well-known member
Staff member
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.

1679547709825.png


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.


1679548630810.png
 
Top