How to build a Twitter and Instagram bot with no code

September 16, 2022
How to build a Twitter and Instagram bot with no code

Creating a Twitter and Instagram bot without code is a quick and easy project. Here’s how I approached it.

I often find myself exploring faraway places on Google Maps. Sometimes I’ll land on a beautiful natural resource like the Grand Canyon or Half Dome in Yosemite, and I’ll notice a bunch of one-star reviews. Something about people who take the time to leave bad reviews of natural splendor is amusing to me. I thought perhaps others might find it funny as well.

So, I decided to find a way to curate these bad reviews and share them with the world. Given I spend most of my social media time on Twitter, I landed on building a Twitter bot that tweets out my favorite of these bad reviews twice per day. I later on decided to throw an Instagram account into the mix since it’s a more visual medium.

I am non-technical, so I needed to find a way to do it using low-code/no-code tools. When I dove it, it turned out to be surprisingly easy. Here’s how I did it.

Collecting the reviews

The most manual part of the process is finding and collecting the bad reviews from Google Maps. I created an Airtable* spreadsheet where I can copy and paste in the bad reviews when I come across them. I collect several bad reviews from same place, so I can quickly add several at once.

Airtable database for collecting the bad reviews I post to my Twitter and Instagram bot
My Airtable database where I collect the funny bad reviews I find

Because there are several fields I have to copy and paste in, I find the Clipboard History feature in Raycast super useful. Raycast lets me copy several items in a row, and then use keyboard shortcuts tto access my copy history quickly. Thus, when I get to my Airtable database I can quickly paste in several fields without flipping back and forth to Google Maps.

Raycast Clipboard History
Raycast Clipboard History saves me a ton of time copying and pasting

I also like to include a nice picture of the place. For that, I use Unsplash, which lets you use any image you find for free.

Use Unsplash to find beautiful photos
Unsplash has tons of beautiful images

Creating the Twitter Bot

Now that I have an extensive database of bad reviews, I need to find a way to start posting them on Twitter. This is a perfect application for Zapier, a workflow automation platform I’m a power user of.

The Zap, or automation, gets triggered using the Zapier Scheduler feature. With this, you pick a time you want your Zap to run daily. Note - because I want to post twice a day I created duplicate versions of the same Zap: one set to trigger and 10am and one at 3pm.

Zapier automation
Overview of the Automation to post to Twitter

When the Zap is triggered, it searches for a record in Airtable. Because I am not searching for any specific record, I have to run the search that basically says “return the first record that isn’t empty”.”As you can see below, I set the search formula as Number!="" which accomplishes that.

Zapier trigger
Triggering the automation to run each day

I limit the search to a view in Airtable I call “To Do” which includes all records that haven’t yet been tweeted.

Next,too avoid tweeting duplicates, I update that found record in Airtable by checking off a field called “Tweeted” which removes that record from the To Do view into a Done view. 

Find record in Airtable
Locating the next record in Airtable with the content I want to post

Now that I have my record ready, I can tweet it. I created a tweet template I like, and then just add in the fields from the Airtable database to populate it. I can even include the picture to go along with the Tweet.

Update record in Airtable
Updating the record so I know it's already been posted

Create Tweet in Twitter
Creating the Tweet

And the final product looks like this:

Next Challenge: Instagram

It was pretty obvious when I started working on this that it’s a very visual piece of content that would work great for Instagram. However, I needed to find a way to programmatically transpose the review onto the image, such as below:

Niagara Falls bad review
Generating an image with the review on it

ITodo that, I am using a tool called Placid. It allows you to create a template with fields that you can populate automatically via Zapier or their native Airtable integration.

Placid template
Placid is an awesome tool for automatically generating images

Now, via Zapier, I can automatically generate these images in Placid.

Create image in Placid
Creating the image in Placid via Zapier

I then created an Instagram account for the project. To auto-post to Insta, you did need a business account.

I added steps to the Twitter Zap to create the image in Placid and then post to Instagram.

Publish photo to Instagram
And finally publishing to Instagram

And voila! I now have an automated Twitter and Instagram bot to post my funny findings. The only remaining manual process is collecting the reviews, which I can do fairly quickly when I run out of content.

Try it yourself!

Grab an Airtable, Zapier, and Placid account if you want to try it yourself. You can even copy my existing Zaps by clicking on this link, and play around with it yourself.

If you create something, please share it with me on Twitter or email me at

* Affiliate link

Let's Talk

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.