Bananajuice2002
Member
Hi Everyone,
I am looking for a solution to my particular case. I run a marketing agency, and my customer signs up for an MMS campaign package subscription via Stripe. The customer's record hits my Airtable with all the information. I have all the data to filter and put into Twilio to send a message, but I cannot solve the issue with the recurrence. It is a monthly subscription, which means my client wants to send those MMS every month, but the records of the payment can appear only once in Airtable(when he/she signs up). The Pabbly scheduler does not work if it is the second part of the workflow. If I put the scheduler first, it will delay the whole process of sending for the next 30 days. Do you have any suggestions on how I can solve the issue with the recurrence? I was thinking about putting an extra cell in Airtable to be able to measure the time, but I cannot even schedule messages inside Twilio.
The initial idea of workflow looks like that:
Workflow:
1. Triger, when new record appears
2. Pull information:
-User Name
-Google Sheets ID and Name (Campaings sheet)
-created date
-messaging level
-owner’s message
-desirable image url
3. Route A
Filter: if level is 100= value 100
Get Rows A:100;I100
Itterator(Simple Response)
Twilio Send Messages (Map info from step 2)
3. Route B
Filter: if level is 200= value 200
Get Rows A:200;I200
Itterator(Simple Response)
Twilio Send Messages (Map info from step 2)
3. Route C.
Filter: if level is 300= value 300
Get Rows A:300;I300
Itterator(Simple Response)
Twilio Send Messages (Map info from step 2)
3. Route ETC.
*** With that setup, I am missing recurrence, I cannot put scheduler inside of the router or After record pulling. I cannot schedule sending date inside Twilio.
I am looking for a solution to my particular case. I run a marketing agency, and my customer signs up for an MMS campaign package subscription via Stripe. The customer's record hits my Airtable with all the information. I have all the data to filter and put into Twilio to send a message, but I cannot solve the issue with the recurrence. It is a monthly subscription, which means my client wants to send those MMS every month, but the records of the payment can appear only once in Airtable(when he/she signs up). The Pabbly scheduler does not work if it is the second part of the workflow. If I put the scheduler first, it will delay the whole process of sending for the next 30 days. Do you have any suggestions on how I can solve the issue with the recurrence? I was thinking about putting an extra cell in Airtable to be able to measure the time, but I cannot even schedule messages inside Twilio.
The initial idea of workflow looks like that:
Workflow:
1. Triger, when new record appears
2. Pull information:
-User Name
-Google Sheets ID and Name (Campaings sheet)
-created date
-messaging level
-owner’s message
-desirable image url
3. Route A
Filter: if level is 100= value 100
Get Rows A:100;I100
Itterator(Simple Response)
Twilio Send Messages (Map info from step 2)
3. Route B
Filter: if level is 200= value 200
Get Rows A:200;I200
Itterator(Simple Response)
Twilio Send Messages (Map info from step 2)
3. Route C.
Filter: if level is 300= value 300
Get Rows A:300;I300
Itterator(Simple Response)
Twilio Send Messages (Map info from step 2)
3. Route ETC.
*** With that setup, I am missing recurrence, I cannot put scheduler inside of the router or After record pulling. I cannot schedule sending date inside Twilio.
