How I built a 'No Code' web flow to get Andaz Apna Apna Dialogues on email
Do you think building things on the Internet is impossible just because you are unfamiliar with coding? 'No Code' is an excellent way to use the power of modern tools to do what you want. Only your creativity limits you.
I have seen Andaz Apna Apna countless times and always wanted to do a project related to this movie. Last weekend, I built this fun project of getting random dialogues from this 90s Bollywood cult film on email. One dialogue at a time. Here's how I did it without writing a single piece of code.
First, I wanted to make a database of Andaz Apna Apna Dialogues. I stumbled upon this Github file from Gaurav Menghani.
I copied these onto a Google Sheet. Next, I used Zapier to build a workflow to trigger an email containing a random quote from the Google Sheet every time I added a new row in a Notion Database. If this seems complicated, let me break it down.
For Testing Purposes, I wanted a trigger for the Zap I was building. A trigger is something that kick-starts the Zapier web flow. Since I am already a massive fan of Notion, I used the simple act of adding an item in a Notion Database as a Trigger for the Zap.
Next, to make the Zap pick a random quote from the Google Sheet, we must use the Random Function to get a random number and then fetch the corresponding dialogue against the selected random number. The RANDBETWEEN(min, max) function in Zapier needs a max value, i.e., the max number of rows in the Google Sheet. For this, I used a Lookup Spreadsheet Row event.
Once we had the Last Row Count in the Sheet, I passed this value as the Max Value in the RANDBETWEEN(min, max) function. I could have hard-coded the last row from the Google Sheet, but that would mean editing the Zap every time I update the Google Sheet.
Once we had the Random Number, it was time to fetch the corresponding dialogue against this number. For this, I used the Lookup Spreadsheet Row event, which fetched the dialogue based on the lookup value.
Once we had the dialogue, I used the Send Email event to shoot emails!
And there you have it! People have built sophisticated websites, web flows, and programs using No Code Tools. If I could do this, anyone can.
I have now modified it to send one dialogue every morning at 8 AM. I wake up with a fresh and funny Andaz Apna Apna Dialogue every morning.
If you want to receive this Andaz Apna Apna email every morning, reply to this post with your email address, and I will try my best to add your email to the Zap. This offer is valid till 31st July 2022 only.