Nocode Weekly Week 5 project has been delayed for a week to launch, it is my first #nocodeweekly project with a proper domain, so it takes quite a bit of time to perfect it.

The concept is pretty simple, I want to do a listing site that features all sort of project / MVP that build with #nocode tools, but I don't want to use a CMS or insert the data manually. I want to update the listing site while I am browsing twitter.

There are a few challenges for me for this project:

The first one is Twitter, I been toying with a few ideas how can Twitter trigger the update, after testing on like, retweet & adding users to list, it seems like using the like action perform the best.

Twitter. It’s what’s happening.
From breaking news and entertainment to sports and politics, get the full story with all the live commentary.

The second issue is how is the site going to display? I choose table2site and Airtable for the site display; I use it for other projects before and I m pretty confident it can serve my need.

Airtable: Organize anything you can imagine
Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.
Table2Site
Build websites without coding. Use your Airtable base as a CMS. Include everything from cards to contact forms.

The last issue is how to transform the data into the format I need. Zapier is a great help here; it helps me to replace some string, format the date so that every day is clean when it inserts into Airtable.

One of the most significant challenges is how to handle the tags filter, and every tweet will have a few tags, I need to collect every tag, make the tags list unique and insert into a specific field in Airtable.

I used zapier to split it, multiple inserts to Google Sheet, consolidate and make the records unique and update back to Airtable. It takes me a few tries to achieve this but I m pretty happy with the results.

Google Sheets: Free Online Spreadsheets for Personal Use
Create a new spreadsheet and edit it with others at the same time — from your computer, phone or tablet. Free with a Google account.
Zapier | The easiest way to automate your work
Connect the apps you use everyday to automate your work and be more productive. 1,500+ apps and easy integrations - get started in minutes.

Give it a try and feedback are welcome.

The site https://nocoder.app/