Andy Cloke

Data Fetcher for Airtable - Run API requests without leaving Airtable

Data Fetcher is an Airtable app that lets you run API requests. Import your marketing data, look up stock prices, send emails or do anything else you can think of using other APIs.

Add a comment

Replies

Best
Andy Cloke
Hi Product Hunt! Really excited to be launching here today 🎉 More and more people are using Airtable to organise their business, but getting data into and out of it can still be fiddly. You either need to do this manually, use a third party service like Zapier/ Integromat or write and host custom code. I built Data Fetcher to solve this. It's really easy to use and lets you run API requests with 0 coding and without leaving Airtable: ✅ Set request URL, headers, parameters and body ✅ Use values from your base in the request URL/body/headers ✅ GET/POST/PATCH/PUT/DELETE all supported ✅ Make paginated requests ✅ Import requests from cURL commands ✅ Import/export API requests as downloadable JSON files ✅ Response field types are inferred. e.g. dates in API response become Airtable date fields. You can also override these ✅ Schedule requests to run hourly/daily/weekly Since it launched a month ago, 300+ early users have made thousands of API requests. Here's some lovely feedback I got recently: "I'm going to be honest with you. Data Fetcher is 100% the reason why we're finally moving our startup platform data over from Google Sheets to Airtable. Thank you for this build! It will take our startup to the next level." It's part of the Airtable app marketplace, so you'll need a PRO subscription to Airtable to installl it. One other thing - I was initially inspired by @a_kravitz's API Connector for Google Sheets, so just want to give her some credit for an awesome product.
B Hari
@a_kravitz @andycloke I have used the product and it is a solid companion to Airtable . Quite friendly and no coders like me could make it work very easily . Am looking forward to templates and more .. strongly support the product .
Andy Cloke
Thanks @harsha99, appreciate the support!
Ana Kravitz
@andycloke This looks awesome, thanks for the mention! Does Airtable have any native API-fetching capabilities or is this a totally new addition to their platform?
Andy Cloke
@andycloke @a_kravitz thanks! I'd say it's a new addition. The closet native capability is probably the scripting app (https://support.airtable.com/hc/...). It has some limitations, which Data Fetcher solves: you'd need to write a new script each time, it does not work if the API does not allow cross origin requests (CORS), your API keys / config would be seen by everyone with access to the base, no scheduling. Another native capability is Automations (https://support.airtable.com/hc/...) which can do a handful of pre-determined actions, like send a Slack message. But if your use case is outside of those actions they wouldn't work.
Glenn McWhinney
Really pleased to see this launch, Andy. I'm a heavy user of automation tools for manipulating data and API's and so having one as good as this actually inside your Bases, sitting right next to your data, is a great move. Even in the early stages of development, Data Fetcher is feature-rich without having a complex interface itself making it ideal for NoCoders, using Airtable, to get to grips with what is often an overly complex UI for managing API's. I think I signed up as a customer after 10 minutes of using it 😊
Andy Cloke
@theflowagency thanks for such a detailed and positive review. Very happy to have you as a customer!
Charlie Ward
Looking forward to trying this out, it looks great.
Andy Cloke
@yungrollneck thanks! Let me know if you want a demo 😊
Bruno Haag
Congrats on the launch! Looks great
Joshua Robertson
Looks great :-)
Joe Anderson
grats bud! Good to see this fully launched, could I use this to build an auto updating job listing scraper (that shows new jobs for certain search terms) using plain urls for example, or does it only work with apis for now. Maybe I need to just combine two services to accomplish that, curious to get your thoughts.
Andy Cloke
@anderson760 thanks! Yeah, you could combine it with https://simplescraper.io/ which will give you an API endpoint for a bunch of scraped URLs. @humanismusic_ is going to publish a guide on this soon actually. If you want to try the API route, here's a list of APIs you could use: https://github.com/public-apis/p.... For example the GitHub Jobs API I'm using above: https://jobs.github.com/position...
Justin Lentz
Wow this is exactly what I was looking for.
Andy Cloke
@justinlentz Great to hear! Let me know if you want a demo. There are guides to all the features here: https://help.datafetcher.io/
Aron Korenblit
I'm extremely excited about what you've built Andy! Being able to easily call APIs from Airtable makes it that much easier for folks to truly create their own software. Can't wait to help you show off what possibilities this opens up!
Andy Cloke
@aronkor thanks, Aron! Looking forward to getting on a stream with you soon
Sebastian Potcher
Wow I like how airtable keep on getting better
Andy Cloke
@sebastian_potcher Airtable's rate of releasing big new features like custom apps (which is what Data Fetcher is) is really impressive. You can see more on their blog here: https://blog.airtable.com/tag/pr...
Jose Alvarado
This is awesome, congrats! I was looking for something like this a few months ago and gave up
Andy Cloke
@imjosealvarado great to hear! Let me know if you want a demo: andy@datafetcher.io
Mike
Super useful app that connects Airtable to data anywhere on the Internet. Opens up a ton of possibilities. Nice work
Andy Cloke
@humanismusic_ thanks Mike! looking forward to getting some simplescraper users set up with it
Harvey Hodd
Love it Andy! Looks super useful.
Jerome Choo
This is quite excellent. APIs used to be out of reach for nocoders due to how involved implementing it is. But tools like this make them 100x more accessible for anyone. Thanks for bringing it to life!
Brian Schmidt
This is AWESOME! Can't wait to use it.
William Houston
Excellent
Mohsin Rafi
@andycloke This looks awesome. Before subscribing I want to know how is it different from Zapier which also provides integration and data fetching. Thank you.
Andy Cloke
@mrafii Try it for free and find out! It’s more Airtable-native than those tools, so no changing tabs, it can create fields for you automatically, handle linked records with ease etc.
Pedron Batoni
Not enough free stuff!