Data is everywhere. Instapaper, To Do tool, Trello list, Google Sheets – we use different online tools for different purposes and sometimes we need to move information from one system to another. For example when we update Trello list, we might want information flow to Google Sheets for some data analysis.
This can be achieved with Zapier which is an online automation tool that connects your favorite apps, such as Gmail, Slack, MailChimp, and over 1,000 more. You do not need to do any programming to connect two apps to automate repetitive tasks.
Bellow will be shown how to connect Trello with Google Sheets.
Prepare Google Sheets.
On the Google Sheets we need to create first row with the header names for columns where you want data to flow.
Here I created row with the columns Board, List, Card, Name, Description, Comment, Label, Due Date.
Configuring Trello Settings.
Now we go to Zapier site and start to create Zap by selecting Make Zap.
We first choose application 1 which will be Trello Application.
Then we select Trigger for example New Activity.
Now we select Trello account, confirm connection, select activity (required). When selecting activity we can select board, list, card. It will then ask to provide sample of activity – go to Trello and create new card with some text.
Then when back to creating zap, pick a sample and it will set for you.
Configuring Google Sheets Settings
Now we select 2nd application – Google Sheets.
We need to specify action, for example – create SpreadSheet Row. This means that trigger action on Trello will cause creating row on Google Sheets.
Now it will ask us connect to Google Sheets
Then we can specify mappings between Trello and Google Sheets fields.
After successful testing our Trello integration with Google Sheets we can click Finish button and turn on our Zap.
Every 15 mins it will check for new activity in Trello and send the data to Google Sheets per our zap.
References
Zapier