How I built a 'No Code' web flow to get Andaz Apna Apna Dialogues on email

Screenshot from my Test emails

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.

Thanks, Gaurav!

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.

Zap Modules

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.

Trigger for the email

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.

Get Last Row in the Google Sheet

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.

My Favorite Function :)

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.

Lookup is easy

Once we had the dialogue, I used the Send Email event to shoot emails!

Poof, it's done.

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.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Avinash Bangera

Avinash Bangera

Product Manager by day; Gaming and Technology Enthusiast by night.