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.

Resync
Hourly automatic re-sync
Manual
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
#<Middleman::Util::EnhancedHash about=#<Middleman::Util::EnhancedHash links=#<Middleman::Util::EnhancedHash angelList="https://angel.co/supadupa-me" application="http://supadupa.me/" crunchBase="https://www.crunchbase.com/organization/supadupa"> text=#<Hashie::Array ["SupaDupa was founded with a rebellious spirit and a lofty objective: to create boutique-quality, classically crafted online shops at a revolutionary price point. SupaDupa was conceived as an alternative to the overpriced, bland, ready-made shops available today.\n", "As the brainchild of Rumble digital agency, a specialist in boutique e-commerce work, SupaDupa benefits of over a decade building successful e-commerce systems. The SupaDupa aesthetic is classically-inspired, with a fashion forward twist - and every boutique can be customised with its’ very own domain name, logo and banner slideshows to match the brand it represents.\n", "Based in London and founded by three friends in 2010, SupaDupa now powers a growing community of independent creatives ranging from artists, fashionistas, jewelery designers and other entrepreneurially minded people with a desire to get their products out there without compromising their design values.\n"]>> customer=#<Middleman::Util::EnhancedHash city_filename="london" location="London" name="Guy Schragger" region="UK" title="CEO and Co-founder"> integrations=#<Hashie::Array ["paypal", "mailchimp", "airbrake", "newrelic", "googleanalytics"]> involvement=#<Hashie::Array ["front-end", "back-end"]> involvementText=#<Hashie::Array ["Railsware helped SupaDupa develop features aimed at extending online boutique themes. The goal was to allow users to go deeper in boutique customization, which was achieved through two levels.\n", "The first one called \"basic customization\" allowed users to play with theme color scheme and font settings. This enabled SupaDupa users to change the look of their shops via simple and easy controls. Every single change (font family, size, color, background etc.) became instantly available in the preview area.\n", "For some more advanced customization an access to most of theme templates and css files was provided, which enabled users to change the theme or insert their own code to improve boutique performance. Also, in the advanced customization mode users were able to upload custom assets and then use them in coding. And on top of that, customization wizard had smart saving algorythm, demo-to-real content switcher and other useful features, all implemented by Railsware.\n"]> name="SupaDupa" page_theme="dark" preview_theme="dark" seo=#<Middleman::Util::EnhancedHash description="SupaDupa was founded with a rebellious spirit and a lofty objective: to create boutique-quality, classically crafted online shops at a revolutionary price point." footer_text="Railsware is a leading offshore Ruby on Rails company which provides contracting and consulting services around the world. We are among the premium ruby on rails development companies on the US market and our team is building top web and mobile applications using Ruby on Rails, React, Angular and more." title="SupaDupa - Ruby On Rails Development in London | Railsware"> slogan="Your stunning, deliberately simple, online store" team=#<Middleman::Util::EnhancedHash engineers=3> technologies=#<Hashie::Array ["rails", "backbone", "marionette", "jquery", "ruby", "js", "coffee", "sass", "haml", "html5", "css3", "mysql", "sidekiq", "aws", "capistrano"]> timeline=#<Middleman::Util::EnhancedHash end="September 2013" start="February 2013">>
SupaDupa
All works
#<Middleman::Util::EnhancedHash about=#<Middleman::Util::EnhancedHash links=#<Middleman::Util::EnhancedHash site="https://www.4finance.com/"> text=#<Hashie::Array ["4finance provides convenient and innovative lending products to customers in 12 countries, while the typical profiles of its customers are people with average incomes, who require a quick and convenient financial solution.\n", "4finance success is based on the careful attention paid to the needs of its customers, as well as strong leadership and management team. The company has already provided more than 5.8 million short-term and installment loans to over 3.3 million customers.\n", "Launched in Latvia in 2008, 4finance is already trading in Toronto, Copenhagen, Stockholm, Warsaw, Riga, Tbilisi, Moscow, Madrid and Kaunas with plans to expand further across the globe.\n"]>> customer=#<Middleman::Util::EnhancedHash city_filename="london" location="London" name="Stuart Watkins" region="UK" title="CIO"> integrations=#<Hashie::Array ["sendgrid", "ldap", "mailtrap", "newrelic", "kissmetrics"]> involvement=#<Hashie::Array ["front-end", "back-end", "system", "graphic"]> involvementText=#<Hashie::Array ["Railsware has taken over Partners Platform project at the early development stage. We rescoped the product based on its goals, benefits it should provide and issues it should solve, and we moved through production to releases in a number of countries.\n", "Our team was handling front-end and back-end development for this product, as well as graphical and UI design. At the same time, our engineers worked closely with the internal development team at 4finance that was responsible for the API development.\n"]> name="4Finance Partners" page_theme="dark" preview_theme="dark" related=#<Middleman::Util::EnhancedHash text="More about our fintech software development services" url="/industry/fintech-software-development/" variation="default"> seo=#<Middleman::Util::EnhancedHash description="4Finance provides convenient and innovative lending products to customers in 12 countries, while the typical profiles of its customers are people with average incomes, who require a quick and convenient financial solution." footer_text="Railsware is a leading offshore Ruby on Rails company which provides contracting and consulting services around the world. We are among the premium ruby on rails development companies on the US market and our team is building top web and mobile applications using Ruby on Rails, React, Angular and more." title="4Finance - Ruby On Rails Development in Riga| Railsware"> slogan="Global Player In Micro Finance" team=#<Middleman::Util::EnhancedHash designers=2 engineers=6 pdms=1> technologies=#<Hashie::Array ["rails", "node", "angular", "jquery", "ruby", "coffee", "sass", "haml", "html5", "css3", "mysql", "aws", "heroku", "ansible"]> timeline=#<Middleman::Util::EnhancedHash end="December 2016" start="September 2014">>
4Finance Partners