How to integrate Google Sheets with Canva to create a folder in Canva when a row is added in Google Sheets

Canva is a useful tool for teams involved in creative work. It allows for real-time sharing of ideas and task management, enabling efficient tracking of project progress.
However, when managing many designs and projects with Canva, the task of creating folders in Canva every time new information is added to Google Sheets can become burdensome.
This article explains the benefits of integrating Google Sheets with Canva and how to set it up.

This article is recommended for

The content introduced this time is recommended for the following people!

Those who use Google Sheets and Canva regularly
Those who have many routine tasks in marketing and want to reduce workload
Those aiming to improve work efficiency by integrating Google Sheets and Canva

Benefits and Examples of Integrating Google Sheets and Canva

Benefit 1: Reduce the Risk of Human Error

The process of manually transferring data between multiple applications is prone to human error.
For example, if a marketing team needs to manually create a folder every time new campaign information is entered into Google Sheets, there is a risk of creating the folder in the wrong place or forgetting to create it altogether.
This risk increases during busy periods or when multiple projects are running simultaneously.
By integrating applications, you can maintain data consistency and reduce the time spent on corrections.
Especially when entering folder names manually, spelling mistakes and inconsistencies can occur, but automation allows the information from Google Sheets to be directly reflected, preventing human errors.
As a result, errors related to folder names and creation locations are reduced, and the time spent on corrections and confirmations is minimized.

Benefit 2: Reduce the Burden on Personnel

Spending a lot of time on routine tasks can lead to decreased motivation and work efficiency.
For example, if the sales planning department manually creates folders in Canva while referring to information in Google Sheets, the more new products there are, the more work and time it takes.
If folder creation tasks are automated, personnel can have more time to think of new ideas and develop strategic plans.
For instance, even if final product information is added to Google Sheets the day before a new product launch, folders will be automatically created in Canva, eliminating the need for manual folder creation.

As a result, personnel are freed from routine tasks like folder creation, and the overall work efficiency of the team is expected to improve.

Benefit 3: Speed Up Information Access

Quick access to information greatly affects work efficiency. Manual folder creation and sharing can cause time lags in accessing information, making it time-consuming to find necessary information.
For example, when the public relations team creates folders in Canva to organize reports and design materials after an event, it may take time to share them with stakeholders.
Additionally, if folder naming conventions are not unified, it can be difficult to know which folder contains what information, potentially causing confusion when stakeholders search for materials.
By automating folder creation, stakeholders can always access the latest information in an organized manner.
This allows personnel to quickly access necessary materials and start working promptly.
As a result, the time team members spend searching for materials is reduced, allowing them to quickly begin tasks.

In this article, we will proceed with integration using Yoom.
If you haven't used it yet, please check out Getting Started with Yoom.

Now, let's explain how to use the no-code tool Yoom to create a folder in Canva when a row is added to Google Sheets.

[What is Yoom]

How to Create a Google Sheets and Canva Integration Flow

It is possible to achieve this by receiving the addition of a row in Google Sheets using the Google Sheets API and creating a folder in Canva using Canva's API.
Generally, programming knowledge is required to achieve this, but with the no-code tool Yoom, it can be easily accomplished without programming knowledge.

The integration flow is broadly created through the following processes:

Register Google Sheets and Canva as My Apps
Set up a trigger to activate when a row is added in Google Sheets
Set up folder creation in Canva
Testing and verification

Step 1: My App Integration with Google Sheets and Canva

First, log in to your Yoom account.
If you don't have an account, please create one on the Yoom account creation page.

1. Click on My Apps and then click on New Connection.

2. You can search by app name in the input field.
This time, search for Google Sheets and Canva respectively and register them.

Register Google Sheets as My App

Let's start by registering Google Sheets. Enter Google Sheets in the input field, and when the Google Sheets icon appears, click on the icon.

1. The following screen will appear.
Click "Sign in with Google".

2. Select the account to integrate.

3. Review the content and click "Next".

4. Review the content and click "Continue".
This completes the registration of Google Sheets as My App.

Register Canva as My App

Similarly, search for Canva and click on the icon.

1. The Canva login screen will appear. Log in with the account you want to integrate.
In this article, we will log in with an email address.

2. The following screen will appear. Review the content and click "Allow".

This concludes the registration of Google Sheets and Canva as My Apps.

Once the My App registration is successful, the following screen will appear.
Check if the icons for Google Sheets and Canva are displayed on the My Apps screen.

For more detailed information about Yoom, please check the Yoom Help Center.

Selecting a Template and Preparing the Storage Location

Click "Try it" from the link below.

If the following message appears, the template copy was successful.

Step 2: Setting the Trigger to Activate When a Row is Added in Google Sheets

This time, since we are using Google Sheets as an app trigger, please refer to the following link.

Notes on Using Google Sheets as an App Trigger

1. First, click on "When a row is added" at the top.

2. Set the title freely.
Enter the account information to link with Google Sheets.
Select "When a row is added" as the trigger.
Once you have finished entering, click "Next".

3. Set each item.
You can select the trigger activation time interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
*Please check as the shortest activation interval varies depending on the plan.
For Spreadsheet ID and Sheet ID, click the input field to display suggestions, and select from them.
Once the settings are complete, click "Test", and if there are no issues, click "Save".

Step 3: Setting Up Folder Creation in Canva

1. Return to the flow. Next, click the "Create Folder" icon.

2. Enter the account information to link with Canva.
Select "Create Folder" as the action.
Once you have finished entering, click "Next".

3. Set each item. Be sure to enter all required fields.
Clicking the input field will display the outputs and suggestions obtained earlier, so use them as needed.
For example, in the screen below, you can use Google Sheets information to name the folder after the client's name.
Once the settings are complete, click "Test", and if there are no issues, click "Save".

4. Finally, click the "Update Record" icon.

5. Enter the account information to link with Google Sheets.
Select "Update Record" as the action.

6. Set up the database integration.
Click the input fields for Spreadsheet ID and Spreadsheet tab name to display suggestions, and select from them.
Once the settings are complete, click "Next".

7. Set the values for the record you want to update.
Click the input field to display the output, and use it as needed.
In the following case, the number obtained from Google Sheets is inserted.

8. Set the values for the record after the update.
In the following case, the folder ID obtained from Canva is inserted into Google Sheets.
Once the setup is complete, click "Test", and if there are no issues, click "Save".

9. This completes the flow of [Creating a folder in Canva when a row is added in Google Sheets].

Step 4: Testing and Verification

Once the setup is complete, the following screen will be displayed.
Click the "Turn on Trigger" button to activate the flow bot.

With Yoom, you can complete the setup without programming.
Try this convenient flow from the link below.

Other Automation Examples Using Google Sheets

There are many other examples of automation using Google Sheets on Yoom, so here are a few.

1. A flow that adds a post to Google Sheets when it is published on WordPress.
Manually transferring information from published posts on WordPress to Google Sheets can hinder work efficiency. By using this template, information is automatically added to Google Sheets when a post is published on WordPress.
This is useful for analyzing post content or sharing it with the team.

2. This is a flow to create a page in Notion when a row is added in Google Sheets.
Manually entering data into Notion after recording new information in Google Sheets is not only time-consuming but also poses the risk of missing records or input errors.
By utilizing this template, a page is automatically generated in Notion at the time information is entered in Google Sheets, allowing for efficient data management.

3. This is a flow to notify Slack when a row is updated in Google Sheets.
If you want to notify Slack of updates in Google Sheets, this template will be useful.
By utilizing this template, you can ensure that team members always have access to the latest information.

Summary

By integrating Google Sheets with Canva, you can now automatically create folders in Canva whenever a new row is added to Google Sheets.
This allows the folder names and contents to be automatically reflected, reducing the errors and verification tasks that often occur with manual work.
With Yoom, you can start automating tasks tailored to your work without any technical knowledge.
Yoom offers a variety of templates, making it easy to implement automation suited to your tasks without hassle.
Why not aim for a smarter way of working by leveraging Yoom?