WooCommerce to Google Sheets – What Info can I send?

Hi @jdyach ,

As long as the order data you want is being stored by the plugin somewhere in the order details, then you can use post meta tokens (https://automatorplugin.com/knowledge-base/post-meta-tokens/) and pass in the ID of the order to retrieve that data. If the plugin uses custom tables, or you’re using Woo HPOS only (https://woocommerce.com/document/high-performance-order-storage/), then you would need to use our DB Query integration instead (or we can track this as a feature request to add an integration for your booking plugin).

As for user data, if this is our free version then it would be a logged in order trigger, in which case you can use a user meta token (https://automatorplugin.com/knowledge-base/user-meta-tokens/) to target the user’s phone number. You will need to know the meta key that’s used to store it though.

Product name is a token you should already see in the list of tokens for the trigger you’re using, though if you want one product per row in the Google Sheet, note that you would need to use a product-based trigger, like ”?A product?has its associated order?completed, paid for, or a thank you page visited”. This trigger does require our Pro plugin.

I hope that helps!