I came accross this stackoverflow question about Google Script to import Trello data to Google Sheets and since we are using Trello in our Team and Google Sheets for Project Management, I thought it might be interesting to have a Google Sheet with all the Trello Cards. I started working on it and I ended up with an interesting script and Google Sheet template, so I thought I'd share it with the world.
I am new to Zapier - like as of yesterday. I am using the tool to transfer data from a Google Sheet Doc to a card on our Trello board. I was able to get the data from the survey to transfer; however, now I want to include the column header as well in the transfer so my team know what the data is.
We needed to submit a report of tasks done during a set period of time. Of course the Google Sheet was the best option to share, but Trello Free version won't let you export a list or cards at all. Trello API - You can use the Trello API to have full programmatic control of the import process Zapier - Zapier is a third-party solution that allows you to integrate over 1,000+ apps with Trello. Using Zapier, you can set up an integration between the other apps you use to manage your work, like Google Sheets, Typeform, and Evernote so that new information in these apps get automatically added as Trello cards. If you are looking for a readymade solution that integrates Google Sheets with Trello (and many more apps), try Sheet Director. This Sheets add-on simply sits on top of Google Sheets to pull and push data from/to Google Sheets from a lot of applications. Use the template shown in the video - Chapters: 0:00 An intro to Automate.io 0:17 Google Sheets t.
The Objective was to get all the cards of a specific Trello Board in a Google Sheet and then create several filters or formulas to have dedicated views, such as 'Todo', 'Doing', 'Statistics' and so on.
Approach
I wrote a script for my Google Sheet using Google Apps Script, to load all the cards of a specific Trello Board in a named sheet. Each time the script is run the sheet gets cleared and the following data are downloaded from the Trello board 'Date', 'Task', 'Desc', 'Who', 'List', 'Link', 'Labels','Label Colors','Checklists', 'Due Date', 'Due Complete'. The script went something like this:
Bookends: Free Shipping on Everything. at Overstock - Your Online Desk Accessories Store! Get 5% in rewards with Club O! That's why we have so many Bookends for sale on our site, including Bookends from brands like Three Posts™ and AllModern. We want to make sure when you're looking for where to buy Bookends online, you're getting the one that's exactly right for you, whether that's the Cycle Non-skid Bookends (Set of 2), the Dog Bookends, or something entirely. Shop our best selection of Bookends to reflect your style and inspire your home. Find the perfect decorative accents at Hayneedle, where you can buy online while you explore our room designs and curated looks for tips, ideas & inspiration to help you along the way. Decorative bookends cheap. Shop Target for Bookends you will love at great low prices. Choose from contactless Same Day Delivery, Drive Up and more. Buy it at the store. Bookends Ridgewood NJ, Upcoming Author Signings, Autographed Books. While we try to ensure that all customers coming to Bookends' signings will meet authors and get their books signed, we cannot guarantee that any or all attendees will meet the author, get a.
The following variables must be defined
To run the function I created a Menu Item using the code below, and created a trigger to run the function every day. After having the data on my Google Sheet, I then created orther sheets for my dedicated views and a nice filter page using the Query() function.
I went a step further and wrote a script to send desired views in a nice email.
Links to a sample spreadsheet
- View: https://drive.google.com/open?id=1_DcS39gq0B8T_Hn3lx8qPi1Ym4bqYt-Nhrbv84aApI8
- Copy: https://docs.google.com/spreadsheets/d/1_DcS39gq0B8T_Hn3lx8qPi1Ym4bqYt-Nhrbv84aApI8/copy
November 27, 2016 / by Drew Wheeler / In education
I came accross this stackoverflow question about Google Script to import Trello data to Google Sheets and since we are using Trello in our Team and Google Sheets for Project Management, I thought it might be interesting to have a Google Sheet with all the Trello Cards. I started working on it and I ended up with an interesting script and Google Sheet template, so I thought I'd share it with the world.
I am new to Zapier - like as of yesterday. I am using the tool to transfer data from a Google Sheet Doc to a card on our Trello board. I was able to get the data from the survey to transfer; however, now I want to include the column header as well in the transfer so my team know what the data is.
We needed to submit a report of tasks done during a set period of time. Of course the Google Sheet was the best option to share, but Trello Free version won't let you export a list or cards at all. Trello API - You can use the Trello API to have full programmatic control of the import process Zapier - Zapier is a third-party solution that allows you to integrate over 1,000+ apps with Trello. Using Zapier, you can set up an integration between the other apps you use to manage your work, like Google Sheets, Typeform, and Evernote so that new information in these apps get automatically added as Trello cards. If you are looking for a readymade solution that integrates Google Sheets with Trello (and many more apps), try Sheet Director. This Sheets add-on simply sits on top of Google Sheets to pull and push data from/to Google Sheets from a lot of applications. Use the template shown in the video - Chapters: 0:00 An intro to Automate.io 0:17 Google Sheets t.
The Objective was to get all the cards of a specific Trello Board in a Google Sheet and then create several filters or formulas to have dedicated views, such as 'Todo', 'Doing', 'Statistics' and so on.
Approach
I wrote a script for my Google Sheet using Google Apps Script, to load all the cards of a specific Trello Board in a named sheet. Each time the script is run the sheet gets cleared and the following data are downloaded from the Trello board 'Date', 'Task', 'Desc', 'Who', 'List', 'Link', 'Labels','Label Colors','Checklists', 'Due Date', 'Due Complete'. The script went something like this:
Bookends: Free Shipping on Everything. at Overstock - Your Online Desk Accessories Store! Get 5% in rewards with Club O! That's why we have so many Bookends for sale on our site, including Bookends from brands like Three Posts™ and AllModern. We want to make sure when you're looking for where to buy Bookends online, you're getting the one that's exactly right for you, whether that's the Cycle Non-skid Bookends (Set of 2), the Dog Bookends, or something entirely. Shop our best selection of Bookends to reflect your style and inspire your home. Find the perfect decorative accents at Hayneedle, where you can buy online while you explore our room designs and curated looks for tips, ideas & inspiration to help you along the way. Decorative bookends cheap. Shop Target for Bookends you will love at great low prices. Choose from contactless Same Day Delivery, Drive Up and more. Buy it at the store. Bookends Ridgewood NJ, Upcoming Author Signings, Autographed Books. While we try to ensure that all customers coming to Bookends' signings will meet authors and get their books signed, we cannot guarantee that any or all attendees will meet the author, get a.
The following variables must be defined
To run the function I created a Menu Item using the code below, and created a trigger to run the function every day. After having the data on my Google Sheet, I then created orther sheets for my dedicated views and a nice filter page using the Query() function.
I went a step further and wrote a script to send desired views in a nice email.
Links to a sample spreadsheet
- View: https://drive.google.com/open?id=1_DcS39gq0B8T_Hn3lx8qPi1Ym4bqYt-Nhrbv84aApI8
- Copy: https://docs.google.com/spreadsheets/d/1_DcS39gq0B8T_Hn3lx8qPi1Ym4bqYt-Nhrbv84aApI8/copy
November 27, 2016 / by Drew Wheeler / In education
Organizing my Teaching with Google Sheets and Trello
Trello Google Calendar
Over the past several weeks I have been using a combination of Google Sheets and Trello for planning and organizing my teaching. It has been amazing! This is one of the first times that I have felt like I have a clear picture of where I am at on the giant list of things that I need to get done. So here is a breakdown of my three systems and how I've been using them. I've included links to the templates, so feel free to make copies for yourself.
1. Google Sheets Weekly Plan (Shared Weekly Plan Template)
I used to use a paper planner for organizing my weeks/months but this never worked well for me. When things changed and I had to scratch things out or draw giant arrows all over the place I ended up more stressed than before I started planning. This led to me trying Google Calendar. This definitely has it's benefits but for me it just seemed to do too much and the base usage that I was looking for was lost in the excess functionality. For example, if I wanted to change some things around it often meant a lot of clicking and editing of times and descriptions. This is when I tried Google Sheets (not sure what took me so long!). I've created a simple weekly template that allows me to just jot down rough descriptions of what the plan is for each of my lessons. I'm able to jump from week to week very quickly and easily to see how my units will line up in the upcoming weeks. If things change it is a quick and easy fix.
2. Google Sheets Unit Plans (Shared Unit Plan Template)
Is Trello Free
Now that I have a clear vision of what my coming weeks are going to look like it is time to lock down the specifics of my units. In the past I relied far too heavily on directories/folders on my computer. I honestly thought that this worked for me (I know better now!). I wanted the ability to quickly look at the bigger picture within my units, see how my lessons are lining up and be able to identify any gaps or issues. I also wanted something that was going to be reusable and easily shared. My units are far from perfect but to be able to continue to adapt and improve them I wanted something that was well documented and clear. This led to creating the template that you see below. It includes the title of the lesson, how many classes it will take, a description of what it will look like, the specific content/learning outcomes, links to all the resources used, and a section for extension material. All the linked resources are organized in my Google Drive.
3. Trello
This is my best discovery! I have used Trello in the past for some mini projects but I never really stuck with using it. I found that the projects that I'd used it for were not quite big enough, so I never gave Trello a chance to really shine. 737 x plane 11. But over the last six months I've taken on some bigger projects and I've been enjoying Trello for these. Then I thought, 'Hey…maybe I can use Trello to help me with keeping track of those million and a half things that I need to get done as a teacher.' I'm only 3 weeks into using it for this purpose, but so far it has been brilliant! I've created a list for my Weekly Plans, Must Do Tasks, No Rush Tasks, In Progress, and Completed Tasks.
Each card in Weekly Plans represents a week and within that card I have checklists for all the lessons that I need to have prepared for each of my courses (using Google Sheet Weekly Planner). Once I have the whole week of lessons planned (using my Google Sheets Unit Planner) I check them all off and move the card to the bottom of the list.
Import Google Sheets To Trello
Must Do and No Rush ListsMy Must Do and No Rush Tasks are exactly what they sound like - all those little and big things that get piled onto our plates as teachers. Whenever another item gets added to my list of things to do I just add it here. I'm then able to sit down and knock things off one by one whenever I have some extra time. Previously I had no tool for these types of things, I just tried to remember them (which had mixed results). This was probably the largest cause of stress for me because I always felt like I had so much to do but never had a clear picture of what all those things were. With Trello I can now sit down and see what I still have to do as well as see what I've already accomplished. I'm now also able to add cards for those things that I should be doing more of but just forget or avoid because I feel like there are other things that I need to get done first. For example, I've added a card for emailing parents with positive remarks regarding their child's work in my math class.
For some of those bigger items that I cannot quite finish all in one sitting. Or also for things that I've started the ball rolling on but still need to do further follow ups on before finishing off.
Thanks for taking the time to read this far! I hope you find some of the information that I have rambled on about useful. I'd love to hear any other tips or tricks that people use to help them with organizing and planning.
