Pull data from any API into Google Sheets in seconds. Pipeline is the easiest way to integrate with all your favorite data sources via API.
API Pipeline is a completely free add-on for Google Sheets that makes it simple to query the data you want from 3rd party apis and services and update it on a schedule with sharing.
Using API Pipeline you can automatically import all of your data into one place in Google Sheets, and easily summarize it, filter it, create pivot tables, chart it, and integrate it with other data. You can build custom dashboards and reports, alters, query, join, sync and manipulate your data. No more cut and pasting csv files, importrange or other difficult ways to combine data and spreadsheets.
Use API Pipeline to export your data from many apps and integrations including:
* Web analytics including Google Analytics, Mixpanel, Heap, Segment
* Performance marketing tools include Google Ads, Facebook Ads, Apple Search Ads, LinkedIn Ads, Microsoft Advertising, Adroll, Taboola, Google Ad Manager (GAM), Adwords
* Apple iTunes
* SEO, SEM and PPC tools like SEMRush, AHrefs, Moz, Google Search Console, Majestic SEO, Bing Services, Yandex
* Mobile ASO Tools like AppTweak, App Annie, SensorTower
* Ecommerce apps including Shopify, WooCommerce
* Email marketing tools including MailChimp, SendGrid, MailGun, Twilio, Unbounce
* Project management tools like Asana, Trello, Jira, ClubHouse, Airtable, Bitbucket, EasyVista
* Social sites including Pinterest, Quora, Instagram, Twitter, Reddit, Snapchat, Vimeo, YouTube, Hootsuite
* Salesforce, Stripe, PayPal, Hubspot, Amazon, GitHub, Wordpress, Zendesk, Pipedrive, Weebly
* Entrepreneurs tools like Craigslist, Angellist, Etsy, Patreon
* Connect to a database table from Google BigQuery, Postgres, MySQL, SQL, RDS, AWS, mongoDB, Redshift, Snowflake, Google Data Studio
* Tax and Accounting with Quickbooks, Xero, Freshbooks
* Pipedrive, Slack, Zoho, Dropbox, Heroku
* Also great for finance, bitcoin and crypto, tracking BTC, ETH at sites like CoinGecko, Binance, Ethermine, CoinMarketCap, CoinBase, MinerStat, FlexPool, CoinAPI, BitPay, BitStamp, BitFinex, Ethereum, CryptoCompare, CoinSpot, Cryptometer, SupportXMR, Poolin, Nanopool, Ethplorer, CryptoWatch (CryptoWat.ch), PancakeSwap, BitKub, IndoDax, KuCoin, Coin Paprika, Nomics and other cryptocurrency and blockchain applications
* Pull in educational and classroom data with Google Classroom
* Other APIs including Dribble (or Dribbble), Strava, Spotify, Harvest, ParseHub, MoviDesk, NSEIndia, Upwork, Torn, HubAPI
You can use it as an API connector to create as many connections as you want, easily refresh connections daily and hourly to stay up to date or refresh real-time. Get all of your data into one spreadsheet to perform cross-channel reporting, cohort analysis, data visualizations and more.
Recommended if you like other scraping & API connection tools like Postman, IFTTT, Insomnia, Zapier, and Supermetrics, Coupler, Simplescraper. Your business can connect virtually any cloud server or platform to build and report on and monitor whatever you want.
Easily manipulate JSON, CSV and XML with dynamic JMES formatting.
Share projects across your domain, create templates to manage client data, campaigns and metrics, track ROAS, mfflove from excel into the cloud, derive insights instantly by merging data sources and sheets, backup and create changelogs, allow data integration without engineers - all no code, harness the power of other add ons like sheetgo, api connector, coupler.io, adstage.io, coefficient.io, merge sheets, supermetrics, archive data with a single free enterprise tool.
We also support advanced and generic APIs and databases via oauth. Try out more esoteric APIs like Alloha.tv, Tracksale, Craftbeerpusher, Algoexplorer, AutoKontinent, Fatture, Julitec, Novadax, TD Ameritrade, Bergamo, Agoda, Yahoo, Open Weather Map, Visual Crossing, Sportradar, Yahoo Finance, Alpha Vantage, NSE India (NSDIndia), Onex Ultimo, FTX
Other services that can be implemented with API Pipeline include: ActiveCampaign, Algolia, AngelList, Anymail, Apify, Autopilot, Aweber, Azure, Basecamp, Bing, Bitbucket, Bubble, Buffer, Calendly, Campaign Monitor, Capsule, Chargebee, Chatfuel, Clearbit, ClickFunnels, Constant Contact, ConvertKit, cPanel, WHM, Dandelion, DataBox, Discord, Disqus, Docupilot, Drip, Egnyte, Elasticsearch, EmailHippo, Etsy, Eventbrite, Evernote, Feedly, Fieldbook, Firebase, Flickr, Foursquare, FreshBooks, FinnHub, Freshdesk, Front, FTP, G2Crowd, GetResponse, GitLab, Google Maps, Gravity Forms, Harvest, Help Scout, HipChat, Hootsuite, HTTP, IFTTT, Indeed, Infusionsoft, Insightly, Integromat, Invoice Ninja, JIRA, Kickbox, KissFlow, Klaviyo, Knack, Leady, LionDesk, Listrak, Magento, Mailgun, Mandrill, ManyChat, Marketo, Mattermark, Mattermost, Medium, Meetup, MessageBird, Microsoft Teams, MongoDB, MonkeyLearn, Moosend, Moz, MyTimeStation, NetSuite, Ninox, OneDrive, OneNote, OpenAI, Paperform, Patreon, PayPal, Pinterest, Pipefy, Pipeline Deals, Pitchbook, Plivo, Plutio, Pocket, Podio, RAYNET, Rebrandly, Recurly, Redshift, RSS and Atom feeds, Runkeeper, Salesflare, Salesforce, ScheduleOnce, Segment, SendGrid, SendinBlue, SendPulse, Sendy, ServiceNow, SFTP, ShipStation, Shopio, SigParser, Slack, Smartsheet, SoundCloud, Spotify, SQL Server, Square, StackExchange, Streak, Stripe, SugarCRM, Survey Monkey, Teamgate, Telegram, Todoist, Toggl, Tumblr, Twilio, Twist, Twitch, Twitter, Typeform, Unbounce, Wasabi, Watson, Webflow, Weebly, Wild Apricot, WooCommerce, WordPress, Wrike, Wufoo, Wunderlist, Xero, YouTube, Zapier, Zendesk, ZeroBounce, Zoho, Notion, Wazirx and many more.