• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $149 (🏆Lifetime Access) - View offer

How to send message to customers only once?

I created a workflow which goes like this. So trigger is a scheduler which will run on every monday at 10 am, then i am extracting data from excel and sending template message of whatsapp using interakt. Now what i want to do is that if the person is added to the excel this message only go once to him and next week monday the message will only go to the newly added customers who haven't received this message. How can do it?
 

ArshilAhmad

Moderator
Staff member
Hi @Nishantmib57,

The use case you are describing is not possible because there is no way to instruct the workflow to start capturing data from a specific row of your spreadsheet, which would result in messages being sent to individuals who were added earlier as well.

However, if you are entering the data of individuals one by one into your spreadsheet, to whom you want to send messages, you can use the workflow given below as an alternative.

This is how it works:

1. You need to enter the data of the person to whom you want to send messages in Google Sheets, ensuring that you have a column with the current date. Pabbly Connect will capture this data through the Google Sheets: New or Updated Spreadsheet Row trigger event.

1683675117084.png



2: To make sure that the messages are sent on the upcoming Monday, add the provided Code to your workflow, which will determine the date of the next Monday and Delay the workflow until then.
Python:
import datetime

def next_monday(date):
    if date.weekday() == 0:  # if input date is already a Monday
        days_to_next_monday = 7  # add 7 days to get to the next Monday
    else:
        days_to_next_monday = (7 - date.weekday()) % 7  # calculate days until next Monday
    next_monday = date + datetime.timedelta(days=days_to_next_monday)
    return next_monday

# Example usage
input_date = datetime.date(2023, 5, 14)  # May 14, 2023
next_monday_date = next_monday(input_date)
print("Input date:", input_date)
print("Next Monday date:", next_monday_date)

3. Add Interarkt as the action event to send WhatsApp messages.
=============================================================================================

The Workflow
1683675393638.png


Please let me know if you have any questions or if this solution meets your use case.
 
Top