Add Customers That Don't Have Store Accounts To A Google Sheets Spreadsheet in Shopify by Using
Mr. Arigato Task Automator
This workflow makes it simple to capture customers that haven't created an account in your Shopify store.
You can now import the ".arigato" workflow file you downloaded into the app.
- Open the Mr. Arigato - Task Automator app in your Shopify admin.
- Visit the "Import & Export" page within the app.
- Scroll to bottom and upload your file to import the workflow.
This example workflow fires when a customer is created. It checks to see if the customer's account status is set to disabled meaning the customer doesn't have an account. Next, it sends customer data to Google Sheets. By default, it will send basic information about the customer to a Google Sheets spreadsheet as cells in a row. You can adjust what data gets sent easily, by using our token browser to find other data points of interest to you.