How to Create a Folder in Canva When a Row is Added in Google Sheets

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

‍

‍

Step 2: Setting up a 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.

Precautions when 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 the input is complete, click "Next".

‍

‍

3. Set each item.
The trigger activation time can be selected at intervals of 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
*Please check as the shortest activation interval varies depending on the plan.
Spreadsheet ID, Sheet ID will display suggestions when you click the input field, so please select from them.
Once the setup is 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 the input is complete, click "Next".

‍

‍

3. Set each item. Please make sure to enter all required fields.
When you click the input field, the previously obtained output and suggestions will be displayed, so please make use of them as needed.
For example, in the screen below, you can use information from Google Sheets to name the folder after the client's name.
Once the setup is 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 linkage.
When you click the input field for Spreadsheet ID and tab name, suggestions will be displayed, so please select from them.
Once the setup is complete, click "Next".

‍

‍

7. Set the values for the record you want to update.
When you click the input field, the output will be displayed, so please make use of it as needed.
In the following case, the No. obtained from Google Sheets is inserted.

‍

‍

8. Set the values for the updated record.
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. With this, the flow of [When a row is added in Google Sheets, create a folder in Canva] is complete.

Step 4: Testing and Confirmation

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 and Canva

In addition to the flow introduced this time, you can achieve various business automations by using the APIs of Google Sheets and Canva.
All of them can be used with simple settings, so if you find something interesting, please give it a try!

Automation Examples Utilizing Google Sheets

Create a folder when a row is added in Google Sheets

This can reduce manual work and may prevent human errors such as mistyping a folder name or forgetting to create it.

Receive an email notification when a row is added or updated in Google Sheets

By integrating Yoom's email feature, it may be possible to prevent human errors such as transcription mistakes and missed notifications.

Add a Record to Google Spreadsheet When an Event is Scheduled

When an event is scheduled, the registration information can be automatically added to a Google Spreadsheet, which should help streamline manual tasks.

Example of Automation Using Canva

Once added and registered, create a folder in Canva

You can quickly create related folders as you add data, which will reduce the chance of mistakes in folder names and contents.

Create a folder in Canva when a response is submitted via the form

This eliminates the need for manual folder management, reduces human error, and maintains data integrity.

Send Canva design download link when a message or response is sent

This eliminates the need to manually send links and helps prevent link omissions or misdelivery.

Benefits of Integrating Google Sheets with Canva

Benefit 1: Reduce the Risk of Human Error

The process of manually transferring data between multiple applications inherently involves human errors.
For example, if the marketing team needs to manually create a folder every time they enter new campaign information into Google Sheets, there might be issues such as creating the folder in the wrong location or forgetting to create it altogether.
By integrating applications, you can maintain data consistency and reduce the time spent on corrections.
Especially when manually entering folder names, spelling mistakes and inconsistencies are common, but automation allows you to directly reflect the information from Google Sheets, helping to prevent human errors in advance.

Benefit 2: Reduce the Burden on Personnel

Spending a lot of time on routine tasks can lead to decreased motivation and efficiency for those responsible.
For instance, if the sales planning department manually creates folders in Canva while referencing information from Google Sheets, the more new products there are, the more work and time it will take.
If the folder creation process is automated, it should allow more time for brainstorming new ideas and developing strategic plans.
For example, even if the final product information is added to Google Sheets the day before a new product launch, a folder will be automatically created in Canva, freeing you from routine tasks and improving the overall efficiency of the team.

Benefit 3: Speed Up Information Access

Manual folder creation and sharing can cause time lags in accessing information, making it time-consuming to find the necessary information.
For example, when the PR team creates folders in Canva to organize reports and design materials after an event, it might take time to share them with stakeholders.
Additionally, if folder naming conventions are not standardized, it can be difficult to know which folder contains what information, potentially causing confusion when stakeholders search for materials.
With automation, folders are automatically created, allowing stakeholders to always access the latest information in an organized manner.
You will be able to quickly access the necessary materials and start working promptly.

Summary

With the integration of Google Sheets and Canva, folders can now be automatically created in Canva after adding a new row in Google Sheets.
This should reduce the errors and verification tasks that commonly occur with manual work, as folder names and contents are automatically reflected.

With Yoom, you can start automating your tasks to suit your needs without technical knowledge.
Yoom offers a variety of templates, making it easy to implement automation tailored to your work.
Why not aim for smarter work by utilizing Yoom?