Fill Excel Spreadsheet from Airtable via automation/intgeration

[Pierre_Lin]

Hello,

My company procurement system runs on excel workbooks. One of the tedious tasks is generating a new PO req and filling out the vendor information.

I have created a table of approved vendors in Airtable. I would like to add an Airtable button, which when clicked would trigger an automation / integration to populate the excel workbook with the information contained in the vendor record.

1. Can a button be used in that way?
2. Are there any suggestions for the integrations to populate excel?

Thanks!

[ScottWorld]

Welcome to the community, @Pierre_Lin!

Yes, this is very easy to setup with a tool like Integromat, which is a low-code automation & integration platform.

Integromat has support for hundreds of apps, including Microsoft Excel, Google Sheets, and Airtable:

Integromat

Microsoft 365 Excel Integrations

Integromat gives you the ability to integrate Microsoft 365 Excel with many other services.

Integromat

Google Sheets Integrations

Shopify, Discord, WooCommerce, Telegram Bot, MailChimp, Facebook: with Integromat, you can connect Google Sheets to hundreds of different apps. Automate repetitive tasks and improve your workflows today!

Integromat

Airtable Integrations

Part spreadsheet, part database, and entirely flexible.

p.s. If you have a budget for this project and you’d like to hire an expert Airtable consultant & Integromat Partner to help you create this, please feel free to contact me through my website at ScottWorld.com:

ScottWorld • Best Airtable Developers, Airtable Experts, Airtable Consulting,...

ScottWorld • Best Airtable Developers, Airtable Experts, Airtable Consulting,...

ScottWorld provides the world's best Airtable consultants, Airtable experts, Airtable developers, FileMaker consultants, and Airtable trainers. Airtable consulting, FileMaker development, and Airtable training.