Creating a dynamic website from a Twitter list and Google Sheet
Tags: twitter, myquicksite, googlesheet
Published: 2020-05-22 14:13:10

---
title: Creating a dynamic website from a Twitter list and Google Sheet
published: true
date: 2020-05-22 08:24:53 UTC
tags: Twitter,MyQuickSite,Google Sheet
canonical_url: https://kambanthemaker.com/creating-a-dynamic-website-from-a-twitter-list-and-google-sheet-ckahxurlo01f9lns1c8q0njlf
---

Integromat, Google Sheet, and MyQuickSite (Update: You can support our ProductHunt launch [here](https://www.producthunt.com/posts/myquicksite)) are the tools I will be using to create a website from Twitter list, you can do the same within 10-15 minutes too. Here is the  [final website](http://philosophy.kambanthemaker.com/) ,

![grid4.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1590126509886/lkyVn91ol.png)

## Twitter List

Twitter lists, curated group of  Twitter accounts. By default Twitter timeline feeds are generated by its algorithm. With lists, you can control who you want to read. A list can be public or private.  [https://twitter.com/i/lists/1148223153291743232](https://twitter.com/i/lists/1148223153291743232) is my Twitter list that we are going to convert into a website.  

## Integromate and Google Sheet
 
They call themselves the glue of internet. Its an automated tool similar to Zapier, you can link any number of services together to create a data flow. https://www.integromat.com/en/integrations lists the list of services supported. Google Sheet has evolved into one of the powerful tools lately. Create a Google Sheet upfront, with the header row. Here is my  [Google Sheet](https://docs.google.com/spreadsheets/d/16T8gpn7QKLcnej0yhkqCc1384OXYIlwAqm_EJluJyHo/edit?usp=sharing)  that I use.


![Screen Shot 2020-05-20 at 6.28.37 PM.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1590128691178/GtI_vkimZ.png)

Lets get into the actual steps, Sign up with Integormat if not already you have an account. Create a new scenario that starting with Twitter, choose the Twitter Search module, we need to search twitter with the list id to the get most recent Tweets,


![Screen Shot 2020-05-20 at 6.11.26 PM.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1590128715984/HWowp_7E3.png)
Then choose one more module Google Sheet Update Row,

Here is the Google Sheet field mapping,


![Screen Shot 2020-05-20 at 6.29.09 PM.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1590128728870/ACQwTsoe0.png)

You can see I am adding the tweet row position with 1 to ignore the header. First tweet will be written on second row of Google Sheet, second tweet will be written on third of Google Sheet, removing previous old tweets. Save the scenarios and configure it to run on a schedule, say every 4 hours.

## MyQuickSite

Coming to the website part, [MyQuickSite](https://myquicksite.com) lets you convert your Google Sheet into a website. This should take only a few minutes. There are predefined templates you can choose or bring your own CSS or combine both. Create an account, add your Google Sheet you created earlier. Rearrange the field if needed to match the template positioning (left to right, top to bottom is the order of resolution), and apply the Twitter list template. You can watch the video (click to play the full video) to get an idea,

**Update** You can support our ProductHunt launch [here](https://www.producthunt.com/posts/myquicksite) 

[![MyQuickSite Demo](https://myquicksite.com/img/banner.gif)](http://www.youtube.com/watch?v=1hzpuxgW1fE "MyQuickSite Demo" "Demo")

You can read my [introductory blog](https://kambanthemaker.com/convert-your-google-sheet-into-a-website-ckahux5cb01cslns1aozc4ll5) for more details.