Thread by @yoheinakajima

1/ How to create a Google Trends for X using Zapier & Airtable 👇

I recently set one up to monitor unique keyword trends in ProductHunt so will use that as an example. #nocode

2/ First you set up your Airtable.

First sheet is to capture the main data, in this case PH data.

In this sheet, create a linked column, and create a new table called keywords (multiple allowed).

3/ Then jump to Zapier, your trigger should be your data source. Can be RSS, webhook, etc. in this case PH. I’m pulling all new products.

You can do this for internal tools too, like notes from your CRM.

4/ The next step is text formatter. I want to see unique words in the PH product description so I take that field and split with a space (“ “), which gives me an array of all the words.

I actually set up one more text formatter before this that made it all lowercase.

5/ Last step of Zapier is pushing this to Airtable. I get the product info (title, descriptions, etc) into the appropriate columns and then take the array of keywords and put it in the linked column of the first sheet.

6/ This automatically populates the keyword sheet w every unique word used, and links them to the PH product. If the keyword exists, it’ll just link that to the new PH product.

7/ Once this zap runs a few times, you can create a “count” column on the keyword sheet to see most commonly used words.

I set up an “ignore” column as a checkbox and use it for common words like “the” “a”, etc and filter it out of view.

8/ To see trends, you create two new count columns, but w additional filtering on the “created date” column (set this up in the PH sheet).

One column is to show keyword count in last month, and the other for the previous month before.

9/ Finally, set up a formula to do 1 minus (this month)/(last month) to see keyword growth percentage MoM.

Sort by this column DESC to automatically see top keywords trending this month.

10/ For more automation hacks like this and other nonsense, follow me!