Woocommerce --> Woocomm Extra Product Options --> WooComm Google Sheets Connector
Budget: $30 – $250 USD
I have data from camp registrations I need to export into Google Sheets. If you have done this in the past, please show me your results. I'm open to other suggestions as long as I don't have to pay big fees every year. Currently my website is using Woocommerce. Then I'm requesting new data via Woocommerce Extra Product Options. From there, I'd like for you to transfer to Google Sheets.
I'm not totally in love with the Woocommerce Extra Product Options because it doesn't seem to validate phone numbers or dates. If you have a better plugin that validates, please let me know.
What is not working is:
1) The developer used Extra Product Options & Add-Ons for WooCommerce plugin for all the registration fields and they aren't coming into Google Sheets as their own separate field. (I was trying Zapier to do this, but am also considering using "WooCommerce Google Sheet Connector") It's just all comma delimited and I needed them split up.
2) I allow for between 1-3 students to be signed up. So what happens to the transfer of data into Sheets if there's only 1 student vs. 3 students?
3) Phone numbers, birthdays, Gender need validation.
4) Once they are in Google Sheets, I'd like to filter by product into its own sub sheets, but I think I can do this on my own. Thank you!
Here's a registration page for reference: https://youngbotbuilders.com/product/wo1/
I'm not totally in love with the Woocommerce Extra Product Options because it doesn't seem to validate phone numbers or dates. If you have a better plugin that validates, please let me know.
What is not working is:
1) The developer used Extra Product Options & Add-Ons for WooCommerce plugin for all the registration fields and they aren't coming into Google Sheets as their own separate field. (I was trying Zapier to do this, but am also considering using "WooCommerce Google Sheet Connector") It's just all comma delimited and I needed them split up.
2) I allow for between 1-3 students to be signed up. So what happens to the transfer of data into Sheets if there's only 1 student vs. 3 students?
3) Phone numbers, birthdays, Gender need validation.
4) Once they are in Google Sheets, I'd like to filter by product into its own sub sheets, but I think I can do this on my own. Thank you!
Here's a registration page for reference: https://youngbotbuilders.com/product/wo1/