Scheduled export of customer list with certain tags to a google spreadsheet

Shopify Plus
1

Hi everyone,

I am looking for a way to export customers with certain tags into a google spreadsheet on a scheduled base.

I know how writing into a google spread sheet works, I know how to filter customers and I know how to set up schedules events.

But somehow I can not find a way to combine those as scheduled triggers don’t offer any customer information or tags as condition to select/filter anything and to write into the spreadsheet afterwards.

Playing around a bit this probably works with the action “get customer data” and a custom query … but sadly thats all I got on my mind so far.

Any hint into the right direction or perhaps even the suitable query would be highly appreciated!

Kindest regards from Germany

Armin

2

I got the entire workflow to work triggered manually or upon customer creation (using conditions and actions), but can’t get it to work in any way to get it scheduled.

3

Update: I actually got it to work now with the simple query

tag=requiredtag

What I now can’t get to work is the proper formating in the spreadsheet where every customers data should be in a single line.

Here the related questions I asked regarding it:
https://community.shopify.com/c/shopify-flow-app/flow-adding-rows-to-spread-sheets-from-quot-get-customer-data/td-p/1944381