Airtable Importer intro

Airtable Importer

Google Spreadsheets add-on for Airtable import

About

Accounting, recordkeeping, data blending… No matter what the “major” of your company is, you definitely face that data challenge. Not surprisingly, in Railsware we solved the issue with Google Spreadsheets.

Later, having discovered Airtable, an awesome database tool, we loved it right away for the way it’s organised and well-thought and started using it extensively. But what we really missed there was that "GSheet magic": ability to do advanced calculations, filtering, pivot tables etc. Working closely with both tools, we suddenly realised it would be an amazing gain to combine those two. With that in mind, Railswarians developed an add-on, Airtable Importer, as a missing link between Airtable and Google Spreadsheets.

Easily import table from Airtable to a Google Spreadsheet. Keep spreadsheets actual with hourly automatic re-sync of imported Airtable to the linked sheet. Or enforce the update with manual re-sync whenever it’s needed. Just get maximum impact from Airtable easiness and Google Spreadsheets power.

Hourly automatic re-sync
Manual re-sync possibility
Yaroslav Lazor
CEO, Railsware

It's a really nice start of a plugin. Saves me a lot of time importing AirTable data into Gsheet to do my Gsheet magic in it. Thank you!

Eugene Tsvetukhin
Product Manager, Mailtrap

Once configured it just works and saves ton of time. Allows you to keep critical data in Airtable and import into google sheets for analytics and calculations.

I use this plugin on daily basis as it saves a lot of time and effort when playing with few Airtable bases and ton of Spreadsheets using Airtable as a datasource.
Artur Kasprzyk
VP of Operations, Railsware

Involvement

Airtable Importer is another example of a tool originally created by Railsware for internal use. With our particular needs solved, we thought it would be a good idea to share our add-on with the community. Combining powers of two great database tools - Airtable and Google Spreadsheets - we do hope it will make your lives easier. Enjoy for free!

Front-End
Support
System Integration

Technologies

Airtable
JavaScript
jQuery
Google Drive
{"name"=>"Brightbytes", "preview_theme"=>"light", "page_theme"=>"light", "slogan"=>"Research-based Decision Support Platform", "about"=>{"links"=>{"application"=>"http://brightbytes.net", "crunchBase"=>"https://www.crunchbase.com/organization/brightbytes", "angelList"=>"https://angel.co/brightbytes-1"}, "text"=>["BrightBytes online data analytics platform gathers ideas from best experts in the world and creates evidence-based frameworks that are combined with data from your school or region, giving you the tools to understand and quickly improve student learning outcomes. BrightBytes solutions are specifically designed to address unique needs of educational leaders globally.\n", "Clarity, their flagship platform, is used by educators in almost all U.S. states to make quick, effective decisions that improve student learning. BrightBytes' secret sauce is a unique blend of talented educators with deep experience in K-12, gifted engineers building the next generation data platform, and world-class data scientists analyzing ways to improve student learning outcomes.\n"]}, "customer"=>{"name"=>"Jake Becker", "title"=>"Director of Product", "location"=>"San Francisco", "region"=>"CA, USA", "city_filename"=>"san-francisco", "testimonials"=>["brightbytes-becker"], "testimonials_short"=>false}, "team"=>{"engineers"=>8}, "timeline"=>{"start"=>"August 2013", "end"=>"Now"}, "video"=>{"code"=>"m36b3pjd0u", "quote"=>"What the Inception process has done within BrightBytes is really brought some structure to the product management process and deep understanding of what we're building.\n"}, "involvementText"=>["Railsware has extended BrightBytes tech team with our front-end and back-end engineers to help build complicated parts of projects and thus achieve product and business goals. Our engineers are working with BrightBytes team both on-site and remotely to ensure the best collaboration, as well as sharing our best engineering practices to help increase the code quality.\n"], "involvement"=>["front-end", "back-end", "system"], "technologies"=>["rails", "angular", "jquery", "ruby", "js", "sass", "html5", "css3", "psql", "mongo", "redis", "memcache", "delayed-job", "aws", "heroku", "capistrano", "chef"], "integrations"=>["facebook", "twitter", "googleauth", "googlemaps", "sendgrid", "mailtrap", "heroku", "aws", "newrelic", "mixpanel", "googleanalytics"], "seo"=>{"title"=>"BrightBytes - Ruby On Rails Development in San Francisco | Railsware", "description"=>"Page description", "keywords"=>"Page keywords", "footer_text"=>"Railsware is a leading Ruby on Rails company"}}
Brightbytes
All works
{"name"=>"Smart Checklist", "preview_theme"=>"dark", "page_theme"=>"dark", "own_product"=>true, "primary_color"=>"#00caca", "slogan"=>"JIRA add-on for checklists organizing using Markdown support", "about"=>{"links"=>{"application"=>"https://marketplace.atlassian.com/plugins/rw-smart-checklists/cloud/overview"}, "text"=>["We’ve moved to JIRA after using Trello for quite a while. Trello was pretty good as it provided our team with great functionality on managing Project boards and single Tickets, but most importantly – with checklists embedded in Trello cards. However, JIRA seemed to have some great support of custom statuses, workflows, APIs and service desk project types, so we decided to switch. As we handle various projects, from Software Development to managing Company Structure, we needed a place to describe repeatable processes, from release instructions to office plants care. Essentially, we required a substitution for Trello checklists.\n", "There’re subtasks in JIRA which are basically same as JIRA ticket, but located 1 level below your current issue and linked to it. And it works OK for tasks with bigger context. However, often you don’t need that overhead, but rather to put up to 10 To Do items or Definition of Done criteria or other steps and instructions for task execution.\n", "Managing such an activity through JIRA subtasks is time-consuming sort of pain. Therefore we decided to implement Smart Checklist add-on and it became a very useful part of our JIRA infrastructure.\n"]}, "customer"=>{"name"=>"StiltSoft", "title"=>"Top 5 New Add-ons for Atlassian JIRA – Second Quarter 2016", "city_filename"=>"example", "multi_testimonials"=>true, "testimonials"=>nil}, "video"=>{"code"=>"klo2rvtxyg", "quote"=>"Smart Checklists is a great free and simple-to-use add-on for JIRA Cloud. This is a great portable organizer that after a little bit of setting up your JIRA will always be at your fingertips\n"}, "involvementText"=>["Smart Checklist for JIRA Cloud is a good example of the tool that has been initially created by Railsware team for internal use and then shared freely with other developers later on. The product idea has come naturally out of the needs our team had and been developed by Railswarians from scoping and design to the technical implementation and support.\n", "Smart Checklist for JIRA Cloud development is still on as we’re introducing paid version of add-on with more features included.\n"], "involvement"=>["back-end", "front-end", "graphic", "interaction", "support", "system"], "technologies"=>["reactjs", "node", "jquery", "js", "sass", "html5", "css3"], "integrations"=>["jira", "segment", "intercom", "googleanalytics", "mixpanel"], "seo"=>{"title"=>"Smart Checklist for JIRA by Railsware", "description"=>"Smart Checklist add-on for JIRA Cloud help you to organize small and big checklists inside JIRA ticket in an extremely easy way. It’s achieved by using the power of Markdown, extended details per checklist item and ability to populate checklist content with JIRA API"}, "statistics"=>[{"number"=>420, "description"=>"installs", "icon"=>"graph"}, {"number"=>"14K", "description"=>"users", "icon"=>"3d-graph"}]}
Smart Checklist