Google sheet one of the perfect tools you can use for dropshipping and ecommerce. This integration allows you to sync your leads and sales automatically from your funnels to your sheets in real time. This way, you can keep track of your progress and make data-driven decisions to improve your business.
How does it work?
Log in to your account and go to Apps
Install Google sheet integration and select the type of collected data
Pick the funnels (or all funnels) you want to sync with your sheet
Finally, start mapping, in this step you can add the columns that you need or remove the ones that you don’t need then to finish click on “Next”
Advanced settings:
At the bottom of every sheet you will find these options
This option allows you to group items with same order ID in one row, group items can be (variants, bundle offers…)
This is perfect if you are using cash on delivery as a payment method, your abandoned checkout are forever not lost.
Important note:
In case you can’t find a field in the sheet, you can add custom field
And match it with the form you have in your funnel