Automatically backup a Notion Database to Google Drive

Introduction

CSV Getter is a data export platform that allows you to connect to your favourite no-code platforms to create automated data pipelines. The platform allows you to understand what data you are exporting and where it is going. In this guide, we will show you how to schedule a complete Notion database backup to Google Drive using Make.com and CSV Getter. Your Google Drive file will have your latest Notion database snapshot and will be updated at a frequency of your choosing.

Step 1.

Create an Notion Export URL or test this process with our demo URL available to copy and paste below.

https://api.csvgetter.com/15SpsAURiAXlKSzZeORq

A URL like this will download the current data from this Notion database.

Step 2.

Log on to Make.com, and create a new scenario.

Step 3.

Press the large "+" button to add a new action and under HTTP, choose Get a file.

Step 4.

Add your CSV Getter export URL as the URL for HTTP.

If you would like to see an example of adding an HTTP bearer token to your URL in advanced settings, then check out this article.

Step 5.

Add a second action, a destination cloud drive of your choosing. Google Drive is used in this tutorial. On the Google Drive action, click Upload a file.

Step 6:

Fill out the fields required for the action. For the file, you can choose the file retrieved from the HTTP module.

Step 7:

Test your scenario by pressing 'Run once'. Once this is complete, you will see your CSV Backup in Google Drive.

When you are happy your scenario is working, you can turn it on and select a schedule, and your Notion database will be backed up automatically.

(Optional) Step 8:

Get notified of each backup using further Make actions. The below screenshot will give you an idea of how Make modules can be used in synchronisation.