I’d love your feedback on a tool we’re working on, called Scripts.
What is it? An extension that embeds an onsite code editor into your bases.
Why would I need that? If you’ve ever used Google Scripts or VBA for automating spreadsheets, this is the same for Airtable.
It makes it easy to build custom alerts, automations, workflows, reports, and integrations for your bases, using short Python scripts. The extension handles API calls behind the scenes (even as the Airtable API is quite limiting), OAuth with other apps you’re integrating with, hosting, and more.
Who is it for? It’s designed for power users with a bit of Python experience, automation geeks, or API developers.
What’s the ask? Take the extension for a spin, reply back with your feedback, and don’t share too broadly just yet… we haven’t yet launched!
PS - here are some cool use-cases
Build an Google Sheets Export/Import integration in 60 seconds
Setup mail merge in Airtable
At least according to the Airtable API docs, it doesn’t seem like Airtable officially supports webhooks. I’m guessing they have a special “on new record” webhook for Zapier, but aren’t ready to enable that for anyone else.
As soon as they launch webhooks - hopefully both ‘on new record’ and ‘on changed record’ - we can enable triggers in the scripting editor. Maybe comment on this feature request in the meantime?
This is quite exciting - but for those looking for a more approachable solution there are ‘push’ Zaps in Zapier.
Also a Chrome extension, this feature adds a small button to the Chrome tool bar from which specific Zaps can be directly triggered. This is what it looks like:
The example push zap will update the specific employee’s record being displayed in the Expanded view.
I’ll write a blog post about this in the next few days…
Just a heads-up: this service is neither officially endorsed nor vetted by Airtable. Airtable cannot vouch for the security credentials of this third-party service, and if you choose to make use of this service, you do so at your own risk. Please be careful when potentially exposing your Airtable data to third-party services, especially if you are using Airtable to store sensitive information.
Hey @Paul_K, I’ve added the chrome extension, refreshed the browser, clicked the green leaf and hit allow scripts for base but nothing happens after that (no pop-up window etc). I’ve disabled uBlock and Ghostery and still nothing. I wonder if you are able to help?
Had just removed both extensions (Ghostery, uBlock Origin) and still no success, I’ve inlcuded a screengrab of the other extentions below:
Whatfont? The great suspender, metamask, ethereum network, grammerly, honey, tradingview, google calendar, bitmex and blockspring
Hey Paul - I’ve just noticed that a couple of other users are having issues with it working in Airtable also after looking at the app reviews, hopefully this may be of some help to you. I’ve removed all extensions and still no success.
“Not working with Airtable. After clicking icon in bottom left and clicking ok on popup nothing happens. Checking the console shows a uncaught typeerror. Community site down. Slack channel is pretty dead. Please help. Would love to get give the Airtable Mail Merge a try. Thanks.”