Solved

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

RennWelten
Excursionist
29 3 4

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

 

Accepted Solution (1)

RennWelten
Excursionist
29 3 4

This is an accepted solution.

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-cus...

 

 

View solution in original post

Replies 2 (2)

RennWelten
Excursionist
29 3 4

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.

RennWelten
Excursionist
29 3 4

This is an accepted solution.

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-cus...