Microsoft Office 365 is a complete suite of home and enterprise-grade applications like Excel, Outlook, Word, SharePoint, OneNote, OneDrive, and more. Microsoft Office 365 is offered in several plans to suit your personal and business needs.
Airtable is a powerful database, with a simple interface. Whether you're building a database to manage the team, to track a product launch, or to brainstorm new ideas for your business, Airtable is flexible enough to let you focus on the work.Airtable Integrations
Office 365 + AirtableUpdate Record in Airtable when New Calendar is created in Office 365 Read More...
Office 365 + AirtableUpdate Record in Airtable when New Contact is created in Office 365 Read More...
It's easy to connect Office 365 + Airtable without coding knowledge. Start creating your own business flow.
Triggers once you add a new calendar.
Triggers when a new contact is added to your account
Triggers when a new e-mail is received in your inbox.
Triggers when a new event is created in your calendar.
Triggers when a new record is available.
Triggers when a new record is available.
Creates a new contact.
Create an event in the calendar of your choice.
Send an email from your Outlook account.
Creates a new record with auto-populating fields.
Update the values of specific cells in an Airtable record.
This paper will explain what is Office 365 and Airtable, how they integrate and the benefits of integrating these two products.
Office 365 is a cloud-based suite that provides a wide range of applications through a single interface. These applications include email services, calendar, task manager, file storage, online meetings and video conferencing, instant messaging and online document cplaboration. Office 365 also supports some third party apps such as Yammer and Skype for Business.
Airtable is a database software based on Visual Basic for Applications (VBA. or Python. It allows users to construct structured tables and manipulate data by adding rows, fields, and reference to other tables.
In this section, I will demonstrate and discuss how Office 365 and Airtable integrate and what are the benefits that come from integrating these two products.
Integration between Office 365 and Airtable is easy because both products use the same programming language – VBA/Python. Office 365 uses VBA for its applications, where as Airtable uses Python for its database software. Integration of Office 365 and Airtable can be done by connecting them through an Excel sheet, which can be achieved in three steps:
Step 1. Create an Airtable account by visiting http://airtable.com/.
Step 2. Upload an Excel sheet, containing the details of your company’s employees, to your Airtable account. Add new rows to the excel sheet if necessary.
Step 3. Then establish a connection between the Airtable account and Office 365 using Zapier by visiting https://zapier.com/. The integration process consists of three steps:
From the left side navigation of the webpage, click “Connect Office 365 to Airtable” then select the service that you want to connect. In this case, we will connect “Office 365 Outlook Contacts” with “Airtable” service. Then choose the items that you want to connect, in this case “Office 365 Outlook Contacts” and “Airtable”, then click “Connect” button. On the next page, you need to enter the API Key of your Office 365 account (which is available from the Admin panel > User settings), then click “Connect” button again. In the last step, you will be taken back to Zapier page where you will see the status of your connection. Click “Done” button once you see a green tick on the right side of each row in the table.
You can switch between different options under “Zap your stuff together!” to test how they work together. To see what happens when you run a zap, click the play button next to the zap name in the table at the bottom of the screen. You can change any part of your zap by clicking on it in the table at the bottom of your screen then editing it on the right-hand side of your screen. For example, if you want to change which data you are pushing into your sheet, click on the “Run this step” option in the table at the bottom of your screen then select a different step from the dropdown menu on the right-hand side of your screen. You should save any changes you make to your zap before running it again as they can only be made once. If you want to stop using a zap without deleting it permanently, you can disconnect it by clicking on “Disconnect” in its row in the table at the bottom of your screen then clicking “Disconnect” again on the warning message box that appears.
Once you have completed these steps, you should be able to see your data in Office 365 inside an Excel sheet within seconds after logging in to your Office 365 account from within Airtable account. However, there are some limitations with this integration such as having to create an Excel document in every instance when creating a new employee record in Airtable and that once you delete a field from your excel sheet, it will not disappear from your list but will still be visible on name and email fields in Office 365 which might cause confusion among users working on this integration. There is also no option for a user to edit an existing employee record directly from their Office 365 Outlook Contacts list. To achieve this feature, one needs to create an Edit form inside his/her Airtable account then connect it to Office 365 Outlook Contacts via Zapier just like in Step 2 above (see screenshot below. This Edit form allows users to edit fields directly from their Office 365 Outlook Contacts list without having to open their Airtable account or Excel sheets. To do this integration, click on “Edit Form” then select “Add Field” button as shown below. After selecting “Add Field” button, you will see another pop-up box where you need to type all of your existing fields into a corresponding cpumn as shown below:
Then click on “Save & Close” button after entering all fields required for your Edit Form. Now go back to Zapier page and click on “Edit this Zap” under Step 2 (see screenshot below. Select “Office 365 Outlook Contacts” from Step 1 then select “Edit Form” option from Step 2 as shown below. Then copy/paste URL of your Edit Form into URL field under Step 2 as shown below. Then enter API Key of your Office 365 account into API Key field under Step 2 (see screenshot below). Click on “Save & Test” button under Step 3 to test if this integration works properly or not (see screenshot below. Your screen should look like this if everything goes according to plan. After saving this integration, go back to your Edit form in Airtable then log out from your Office 365 account and log back into it again from within Airtable account (see screenshot below). Now try editing one field of an employee record (see screenshot below). As you can see from the previous screenshot above all changes are saved automatically when we exit our Edit form, thus eliminating any manual intervention during editing process which saves time and effort for administrators who manage large number of employees within their organizations. Another benefit of this integration is that after creating/editing employee records within our Edit form inside our Airtable account we can return back to our Office 365 Outlook Contacts list without losing any changes made within our Edit form or Excel sheets since all changes are directly synced with our Office 365 account without us having to download or upload anything manually before returning back to our Office 365 Outlook Contacts list (see screenshots below). This integration has many benefits including saving time and effort by eliminating manual intervention during editing process and instead being automatically updated in both systems once we log out from our Edit forms or Excel sheets and log back into our Office 365 accounts from within our Airtable accounts (see screenshots below):
Apart from integrating with Outlook Contacts list through Zapier there are also other alternatives available for integrating Office 365 with Airtable such as connecting them with Google Sheets or accessing Microsoft Graph API directly through code snippets for those who are more familiar with Python programming language than VBA (Visual Basic for Applications. However, these methods require more technical skills such as understanding how each method works and knowing how certain parts of code interact with each other which might be challenging for non-technical people or those who don’t have much experience with programming languages such as VBA or Python. Thus Microsoft recommends using Zapier as it simplifies integration process by allowing users to combine actions across different apps without writing any program codes themselves which makes integration process easier for everyone who doesn’t have enough technical skills or don’t have much experience with programming languages like VBA or Python mentioned in previous paragraph above.
Our organization is currently using Office 365 together with Airtable because we have realized that integration between these two products provide us with numerous benefits such as increasing productivity by providing us with immediate access to critical information about our company employees as well as having real-time access to our company employees data from anywhere/anytime via our mobile devices which reduces delays caused by contacting cpleagues or sending emails for information requests about specific employees therefore increasing efficiency within our organization resulting in reduced costs. Moreover integrating both products has allowed us to automate several actions such as editing employee records which saves time and effort for administrators as well as reusing existing data which helps reduce errors while entering information since information is already available within our existing databases rather than having to start over again when entering
The process to integrate Office 365 and Airtable may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.