How to integrate Webflow with Microsoft Excel to automatically accumulate collection information in Microsoft Excel

When you receive a lot of emails every day, it can be quite a hassle to save files to Dropbox each time.
Moreover, many people might have experienced the struggle of missing a file save or saving a file in the wrong folder, making it difficult to find later.

In this article, we will introduce a method to automatically save files received in Gmail to Dropbox!

By using no-code tools, you can easily set up automation between Gmail and Dropbox.
You can start using it right away, so be sure to give it a try!

Recommended for

• Those who want to automatically upload files attached to Gmail to Dropbox
• Those who want to integrate Gmail and Dropbox to facilitate smooth file sharing within the team
• Those who want to prevent the loss of attachments and ensure proper document storage

For those who want to try it immediately

In this article, we will introduce the integration method using the no-code tool "Yoom".

No complicated settings or operations are required, and even non-engineers can easily achieve it.

You can start right away using the template below, so please give it a try!

Webflow allows you to visually build websites without programming knowledge and is utilized by many companies. By integrating this convenient tool with Microsoft Excel, website updates and content progress management can be conducted more smoothly. For example, by automatically adding collection data to Microsoft Excel, you can grasp the creation date, last update date, and archive status of content in real-time, reducing the workload of web administrators and project managers.

Traditional integration methods required programming and could be cumbersome to set up. Therefore, we offer a Flowbot template that can be easily implemented without code. This article explains the setup method without programming and specific usage methods, so please read to the end.

Two Benefits of Integrating Webflow with Microsoft Excel

From the perspective of web administrators and project managers, we considered specific benefits of automation.

Benefit 1: Smooth Website Updates and Maintenance

By automatically adding data from Webflow to Microsoft Excel, site operators can instantly grasp the creation date, last update date, and archive status of items. This allows you to quickly check which content is up-to-date and which is outdated, prioritizing necessary updates. Especially when managing multiple pages and content, there is no need to manually track data, ensuring the entire site is always up-to-date. As a result, the accuracy of information provided to users improves, and the reliability of the website is expected to increase.

Benefit 2: Easy Grasp of Progress Management and Content Status

With Webflow's collection data automatically reflected in Microsoft Excel, project managers can check the progress of content in real-time. For example, based on the creation date and last publication date of items, you can instantly see which projects are ongoing and which content is completed, allowing you to quickly move to the next step. This saves the trouble of individually checking the progress of each task, making communication among members more efficient. Furthermore, by grasping archived content, you can accurately determine project priorities and re-editing timing, ensuring smooth progress of the overall project plan.

[What is Yoom]

Here, we will explain how to create automation using Yoom's template to "add items created in Webflow to Microsoft Excel."

‍

Try it from the free plan! Please proceed to register first♪

＞Register for free with Yoom

※Microsoft 365 (formerly Office365) has plans for home use and general corporate use (Microsoft 365 Business). Depending on your environment (if you are not subscribed to the general corporate plan), authentication may not work properly, so please be aware.

How to Create a Flow for Integrating Webflow and Microsoft Excel

Things to Prepare in Advance

Here are the items needed for the integration work.

Webflow

• Access Token
  • Select the target site in the Webflow dashboard.
  • Proceed to "Site Settings" and click "Apps & Integrations."
  • In the "API Access" tab, issue an API token.
  • When issuing the API token, set the "Read and Write" permissions for "CMS" and "Sites."

Microsoft Excel

Integration with Microsoft Excel is done using Microsoft Sharepoint or OneDrive. Therefore, it integrates with Microsoft 365.

• Microsoft 365 login information
• For this introduction, please prepare a test environment for Microsoft Sharepoint.
  • Site creation
  • Upload the Microsoft Excel to which records will be added. Since the table recognizes the first row as a header, create items in the first row columns.
    ※Insert a unique key in the items. If there are duplicate values, it is important to make it easy for the system to identify which value it is, such as by assigning serial numbers.

Step 1: Register My Apps

First, register the app to be integrated with Yoom. Log in to Yoom's workspace and click the new connection button from My Apps in the menu bar.

A list of apps that can be connected with Yoom will be displayed. Search for the app to be connected from the search window at the top and proceed with My Apps registration.

‍

Webflow

Search for "Webflow" and click the app name that appears. This screen will be displayed.

Enter any string (such as an email address) for the account name and the value obtained from Webflow for the access token, then click the add button.

Microsoft Excel

Search for "Microsoft Excel" and click the app name that appears. The screen will switch to enter Microsoft account information.

After entering the account information, click the add button to complete the My Apps registration.

Step 2: Copy Yoom's Template to My Project

Click this banner. The template will be copied to "My Project" in the Yoom workspace.