Motivation 🤓
Being someone who enjoys learning and would like to soak up as much knowledge as possible, I have accumulated a list of books on Google Keep that I want to read over time. Since I came across the idea of building my “library” on Notion, I wanted to transfer the list of books to Notion. However, the copy-pasting and manual data entry doesn’t sound fun, especially when the list is close to 80 books. After a few trials and errors, I managed to find a way to automate this process.
New to Notion? Check out the link at the “Notes” section for free templates!
Requirements ⚓
Automate get and create book data entry on Notion
- Data involved → book title, author, and cover URL
- Data source → Amazon website
- Tools → Google sheet, Notion and Zapier
The “how” 💡
Part I: Import data using Google Sheet
Create a new Google Sheet with the following headers and formulas.
Header |
Purpose |
Formula |
---|---|---|
Amazon URL |
Data source |
Paste book URL of your choice (cell = A3) |
Book title |
Get book title |
|
Author |
Get author |
|
Cover URL |
Get cover image |
|
Send to Zapier |
Trigger column for Zapier |
Insert a checkbox for all cells in this column |
Part II: Setup Zapier Trigger
Create a new zap trigger - when to trigger Zapier?
-
App event → Google Sheet
-
Trigger event → New or Update Spreadsheet Row
-
Connect to your Google account
-
Select spreadsheet and worksheet
-
Trigger Column → Send to Zapier
Note: whenever there is a change to this column, it will trigger Zapier to get the row data
-
Test Trigger
Note: Zapier will attempt to find a recent item from your trigger app to use in the Zap. Zapier will get row 8 data based on the screenshot above since it’s the most recent item with a checkbox.
Part III: Setup Zapier Action
Create an action - what should Zapier do with the given data?
-
App event → Notion
-
Action event → Create Database Item
-
Set up action
- Database → select the Notion database that should be getting the data
- Match the column in Notion and Google sheet
-
Test Trigger
Note: Most likely, it’s going to be an empty line. Don’t worry! You can have a more accurate test once you turned on the zap.
Final: Turn on the zap and test!
Turn on the zap and go back to your Google sheet. Tick “Send to Zapier” beside the row you wish to send to Notion.
After a few minutes, you should see the data being sent and created in Notion 🎉
Notes 📝
Additional information, limitations, links and references
- For IMPORTXML formula
- Works if (a) it’s Amazon website (b) option = hardcover or paperback. Other options, e.g. Kindle, seem to have a different HTML structure.
- The “author” cell won’t populate when there is more than one author
- It will take some time for every cell to be populated when there are many rows of data
- For Notion to receive the image URL from Zapier, the field property type needs to be “URL”. You can switch the property type back to “files & media” to show the images.
- Free Notion templates to track your reading
- Alternative methods to import external data into Google Sheets
Love this guide? Feel free to buy me a coffee ☕