- 12
- 90 138
Leandro Zubrezki
Приєднався 15 жов 2011
Leandro 🇦🇷 | Founder of Sync2Sheets 🔄 | Solopreneur, ex-freelancer turned SaaS creator | Making Notion sync seamlessly with Google Sheets 📊
How to save emails to Notion from Gmail using Quicktion
Save your emails to Notion with one click!
Quicktion is a Google Workspace Add-On that runs on Gmail and allows you to quickly save your emails to Notion databases.
You first create actions to map the email data to the properties of your database, and then save with a single click while viewing the email.
-- LINKS --
Quicktion:
► quicktion.io/
Install Quicktion for free from the Google Workspace Marketplace:
► workspace.google.com/marketplace/app/quicktion_gmail_to_notion/898671993104
Timestamps:
00:00 What's Quicktion?
01:07 Connecting your Notion workspace
01:57 Creating actions
02:53 Mapping email data to Notion database
04:55 View and save emails with actions
06:40 Saving attachments
8:31 Saving contacts with contacts mapping
9:53 Editing action to add contact mapping
11:10 Saving email with mapping
11:17 Me mixing Notion2Sheets with Quicktion
11:45 Email saved with mapping
Quicktion is a Google Workspace Add-On that runs on Gmail and allows you to quickly save your emails to Notion databases.
You first create actions to map the email data to the properties of your database, and then save with a single click while viewing the email.
-- LINKS --
Quicktion:
► quicktion.io/
Install Quicktion for free from the Google Workspace Marketplace:
► workspace.google.com/marketplace/app/quicktion_gmail_to_notion/898671993104
Timestamps:
00:00 What's Quicktion?
01:07 Connecting your Notion workspace
01:57 Creating actions
02:53 Mapping email data to Notion database
04:55 View and save emails with actions
06:40 Saving attachments
8:31 Saving contacts with contacts mapping
9:53 Editing action to add contact mapping
11:10 Saving email with mapping
11:17 Me mixing Notion2Sheets with Quicktion
11:45 Email saved with mapping
Переглядів: 2 986
Відео
How to create new pages in Notion from rows in Google Sheets
Переглядів 2,1 тис.Рік тому
You can now create new pages in Notion from Google Sheets using Sync2Sheets 🔥 - Use the DRAFT keyword to reserve the row, once you are ready write NEW instead of DRAFT. - All properties are supported, including dates, people, relations and more! - Great for syncing Google Form replies, data that gets populated in Sheets from other services or simple to input data in Notion in a faster way. Inst...
Moving columns after the sync to match Notion order
Переглядів 407Рік тому
From: sync2sheets.com/blog/send-emails-database/
Syncing a Notion TV Shows Tracker database with Google Sheets using Sync2Sheets
Переглядів 1,5 тис.Рік тому
From: sync2sheets.com/blog/imdb-tv-shows-notion/
Creating synced columns for our TV Shows Tracker database
Переглядів 775Рік тому
From sync2sheets.com/blog/imdb-tv-shows-notion/
Google Sheets to Notion simple tables
Переглядів 7 тис.2 роки тому
Keep a sheet from Google Sheets automatically in sync with a simple table in a Notion page! Sheets to Notion - New rows will be automatically added to the table. - Deleted rows will also be deleted from the table. - Great to summarize data and have pivot tables directly in Notion without embeds. sync2sheets.com
How to connect Notion to Google Sheets
Переглядів 52 тис.3 роки тому
This is how you can connect your Notion databases with Google Sheets in minutes. Learn how to install and use Sync2Sheets step-by-step in this full review. Sync2Sheets is a Google Workspace Add-On that gives Notion the superpowers of Google Sheets, allowing you to keep your databases from Notion automatically in sync with Google Sheets. Use Sheets formulas to send data to Notion, create recurri...
Dynamic page titles in Notion with Sheets formulas
Переглядів 1,6 тис.3 роки тому
In this quick video I show how it is possible to set dynamic page titles in Notion using the feature synced columns from Sync2Sheets. In this case the title will be a concatenation of the stock symbol and the current price. This way we can have the current price of the stock in the title automatically updated by Sync2Sheets! Take a look to the full blog post 👉 sync2sheets.com/blog/dynamic-notio...
How to add a synced column in Sync2Sheets
Переглядів 5043 роки тому
Synced columns allows you to sync the values of a column in Sheets to Notion. Use formulas like =GOOGLEFINANCE, =IMPORTXML and keep those values in sync automatically in your database. In this video we will first bulk edit the records, and then create a synced column so Notion gets updated with the new values.
Sync2Sheets - Your Notion databases synchronized with Google Sheets. Automatically.
Переглядів 3,1 тис.3 роки тому
👉 NEW UPDATED VIDEO FULL REVIEW ua-cam.com/video/BPCDGCLs1bE/v-deo.html Sync2Sheets allows you to keep your databases from Notion automatically synchronized with Google Sheets. 👇 How it works? 1. Connect your Notions workspace. 2. Search for databases in your workspace. 3. Start the synchronization process! We take care of the different types of properties. Dates 📅 Email 📧 Created time 🕛 Number...
Your Notion databases in sync with Google Sheets
Переглядів 17 тис.3 роки тому
👉 NEW UPDATED VIDEO FULL REVIEW ua-cam.com/video/BPCDGCLs1bE/v-deo.html Sync2Sheets allows you to keep your databases from Notion automatically synchronized with Google Sheets. Enable the power of spreadsheets to your Notion data. We take care of the different types of properties. Dates 📅, Email 📧, Created time 🕛, Number #️⃣, Phone number 📞, Last edited time 🕝, Checkbox ✅, Rollup 🔍, Last edited...
¿Cómo instalar Jaguar Sheet?
Переглядів 6563 роки тому
Jaguar Sheet te permite sincronizar, guardar y actualizar tus ventas de Mercado Libre de forma automática en una hoja de cálculos de Google Sheet. En este video vamos a mostrar el proceso de instalación y cómo crear y sincronizar tus ventas. Link al sitio web: jaguarsheet.com Link a la extensión: workspace.google.com/marketplace/app/jaguar_sheet/1026696630724
gracias leandro saludos desde chile
La barra lateral no me aparece Para poder iniciar secion en Mercado libre, Gracias por tu respuesta
Hola! Estando en una sheet, abajo a la derecha vas a ver una flecha, con esa flecha podes abrir y cerrar la barra lateral.
Hola. Con esta extensión puedo modificar datos en mi publicación de ML desde GSheets? Por ej: cambiando precios o stock en GSheets y con algún botón decirle que lo actualice en ML. Gracias por tu respuesta.
Hola! No no es para publicaciones, solo sincroniza las ventas. Saludos!
Awesome things. Where I can read mroe about how it works with relations and rollups, coz I am getting tons of errors once doing sync between Notion and sheets.
Contact me at leandro@sync2sheets.com and I can help you checking what's wrong and fix it :)
I got the error on creating the page because of the attachment could not map with notion file & media. What should I do?
Hi! Please reach out to support at leandro@quicktion.io and we can help :)
it is awesome, yet there is no free size to the plan for super small users who want to start a new side hustle
Thanks a ton for the awesome shout-out! Totally get where you're coming from on the free plan bit. Right now, we're noodling on how to make things work for everyone, especially the side hustle crowd and we may introduce a cheaper plan with just one database in the future.
thanks for 0 explanation lol
Sorry for the no audio! If you have any questions you can reach out to leandro@sync2sheets.com
Thanks! Great demo!
Like it ! Thank you.
Hello what will be the use of adding make?
Hi! Sorry I don't understand the question :(
Aguante Argentina papa
Siempre
not sure why someone would pay more for this than they do for notion, but more power to you.,
Because Notion is a VC backed company with millions of dollars while Notion2Sheets is a single person company with no outside investment.
@@LeanZubrezki this is a function and should be a feature bundled with the app and the fact that it isnt only leaves scum bag SAAS models thinking they are entitled to a monthly service fee. Paying a monthly fee for a function is zzzzz and doing it as a casual personal user is moronic. The SAS model is waaaaay overplayed.
@@brettalanlistens3035 I think is pretty simple, if you don't find value in the add-on you just don't pay for it and that's it. Notion will focus on syncing data TO the platform but not OUT of the platform.
is there a way to have the link to the notion page of the new entry show up on google sheets. I also wish there was a way to use some sort of form to upload screen shots so that it uploads the screenshots in the notion pages content section
Yes by default the Page ID column has the link to the record in Notion! Unfortunately the add-on only works with properties of the page and not the content.
But this is not free. Is there any free tool to automate sync between notion to google sheet?
No there isn't a free plan anymore. You can probably use Zapier or Make depending on your use case but setting them up is complicated.
Blurr
Blurr
Exciting new feature Leandro, going to be a real game changer for how we use it here. It'd be great to see a feature to disable syncing of icons in column titles; as you can't use these column titles with emojis in formulas, which is a massive pain. Currently i'll mirror the column using an array formula and recreate the title so I can use the data. I know you can do it from your side but giving us the option would be nice too. Keep up the good work!
Thanks Tom! We will include new flags to disable icons and to disable formatting, in the meantime you can directly edit the title and remove the emojis or send me an email to leandro.zubrezki@notion2sheets.com and I can configure your account to avoid adding the icons when doing the sync until the feature is released to everyone ;)
Hi Leandro. I am quite excited with how the progress is going on with Notion2Sheets. I want to know if we can edit / modify or delete already added rows in Sheets and will it reflect in Notion?
By default the sync is Notion to Sheets, but you have the synced columns feature to enable edit on existing pages. Basically you make a specific column Sheets to Notion enabling the usage of formulas and more and the rest remain Notion2Sheets. For delete unfortunately no, if you delete the page in Notion or in Sheets you will have to also delete it in the other.
@@LeanZubrezki okay is there going to be any update on my above requirement. Like Sheets2Notion?
@@theaccountantguy well you can do Sheets to Notion now with the feature presented on the video and with synced columns. The only thing that won't work is the deletion of pages and that won't change in the near future :(
@@LeanZubrezki Hi, do yo have planning to introduce sync for Sheets2Notion, meaning the other way round?
@@theaccountantguy you can do Sheets to Notion in different ways! What's displayed in the video is one of them. Send me an email to leandro.zubrezki@notion2sheets.com and we can continue the conversation.
Wow, this guide helped me so much - thanks Leandro!
Great stuff, Leandro! For synced columns, in the video I don't see Date being one of the properties that can be synced. Has that been added, or do you plan to add it?
Thanks John! At the moment date properties are not supported but it is in the roadmap :). One option in the meantime is to use a regular text property and format your date as text directly.
UnFortunately it’s 1way only 🙁 not true 2way sync
Data flows both from Notion to Sheets and from Sheets to Notion but it is not 2 ways for the same column, always one source of truth. There are options for a 2 way sync but they keep a copy of all your data in their servers and are pretty expensive as they charge based on the number of rows.
How to do it so that Notion2sheets does not have access to all our google sheets?
Unfortunately it is not possible to scope down to a single spreadsheet, but even though the add-on could potentially access other spreadsheets it only uses the one you have opened while doing the sync and then it just connects to that one and has no idea about any others.
Hello! Is there any way to make a graph using formula/rollup property?
Yes, when you sync your Notion database both formulas and rollup properties will appear as a column in Sheets. You can then create the chart and embed it back to Notion. Check this blog post for an example: notion2sheets.com/blog/notion-portfolio/
@@LeanZubrezki Will check this out, I tried to enter a database with formulas and rollups and it keeps on showing 0s. Thanks a lot!
@@somerarekpopkdramakvariety692 make sure the related database is shared with the add-on as well. If they are still 0 then please contact Notion support.
Thanks for your video. Is am doing the same to track the daily price . How should I change the stock? Need some support in this
Hi Seng, you can contact us at leandro.zubrezki@notion2sheets.com or take a look at this blog post around the subject, notion2sheets.com/blog/notion-portfolio/
Hello, I can't find sinus & cosinus in notion's formulas. So I thought I could use this sheet to calculate and sync. But it's only 1 way.
Hi Sebastian, you can use synced columns to send data from Sheets to Notion, see ua-cam.com/video/BPCDGCLs1bE/v-deo.html
Hola! Es posible hacer que se creen nuevos registros en el Sheets, y eso se refleje en notion?
i have the same cuestion?
I have the same question
Same
It's awesome! Thanks for your work!
is the sync bi-directional? meaning, if I change the numbers in the tables of notion, does the corresponding google sheet data change?
The sync is only from Sheets to Notion, one way only.
So if I get this correctly - Notion2Sheets passes information from Notion databases to Google Sheets - Notion2Sheets does not pass information from Google Sheets to Notion _databases_ - it does update data from Google Sheets to Notion _tables_ Is there a workaround you would recommend in order to efficiently pass the information from the table to a Notion database? The challenge here is not to mess up the database records...
Hi António! You can pass data from Google Sheets to a Notion database, but not entire records, just specific columns. Let's say you have a list stocks in Notion and you want to have up to date price for them. Then you can sync the database, and use the synced columns feature to make a single column, Price, to be Sheets to Notion, enabling the usage of Sheets formulas but just for that column, and one way only. Let me know if you have any other questions, you can contact me at leandro.zubrezki@notion2sheets.com
@@LeanZubrezki thank you, I will look into it! cheers!
waaa... incredible features !
Always prompting this error "You have reached the max number of databases for this workspace." even when I have only 1 database in a freshly set up workspace. The sync never works too. Always stating "There was an error while syncing your database. Please remove it and try again or contact support."
Hi Ronald! Would you please contact us at leandro.zubrezki@notion2sheets.com so we can give you support and take a look at your case?
what notion should be
Do I have to sync colums every time I change something in sheets ?
No no, values are automatically updated in Notion, the interval will depend on your plan, slowest at once every 6 hours and quicker every 15 minutes.
Is it possible to update a field In notion from Google Sheets? (Not notion to sheets but sheets to notion) Thank you a lot!
Hi Victor! Yes you can do that with synced columns. You can make a specific column to be Sheets to Notion and doing that Notion will be updated with the values from Sheets. You can use formulas for example for calculations!
I have synced my database to sheets but "Synced columns", "Synced cells", and "Recurring tasks" are not showing up. Do you know how I can fix that?
Hi! You need to first enable automatic updates. Once you have your first database in sync the option will appear. After enabling it the rest of the features will be available :)
Me re sirvió! Gracias che
Amazing job! Thanks a lot! Keep going!
Wonderful and inspiring video. Would love to know if Recurring tasks can add values that changes every time it runs, for example, adding a new day or week to a database with the date or week number.
You can use a mix between recurring tasks and synced columns to achieve it. When your page gets created in Notion, it will then be added to Google Sheets as well. Then you can have a synced column with a sheets formula to calculate the number that you want!
This is awesome. I'm working on a template for video production and one of the stumbling blocks was how to connect to google sheets. Very cool, although for some reason I can't make it work syncing a column, it doesn't seem to be updating? Does it take a while first up?
Glad you like it! Once you create the synced columns Notion2Sheets goes and updates Notion with the values, the time it takes to run depends on the number of pages in the databases. If something is not working as expected contact us in notion2sheets.com/contact/ or from the chat and I will be happy to help :)
I installed the program in google sheet and checked the sharing option of notion normally. I've been following your video, but it doesn't work with "Start Sync" disabled. How can I solve this problem?
Hi Park! We just released yesterday a full step by step video here: ua-cam.com/video/BPCDGCLs1bE/v-deo.html. In your case the problem is that your database is lacking Created time and Last edited time properties, go and add the two in Notion and you will be able to start the sync.
There is no sound
It is just showing the process, I promise next time do a full one with audio and video 🙏
I promised and now it is live, full review here -> ua-cam.com/video/BPCDGCLs1bE/v-deo.html
Why does this require permission to access "all your Google Sheets spreadsheets", instead of the permissions that limit access to just "the specific Google Drive files you use with this app"?
Hi Toms!, this is because we need offline access to the spreadsheet to update Notion values while you don't have the app opened. With the permission "the specific Google Drive files you use with this app" we can only access the spreadsheet while Notion2Sheets is opened. We would love to reduce the permissions but unfortunately it is not possible :(
I can't get this to work. I think you have to sign up for Google Workspace. I signed up for the trial but still, I don't get any of these screens after installing it. Why does this have to be so difficult?
Hi Daniel!, I am sorry that you had some issues installing and opening it, I have sent you an email to help you resolve the issue.
Hi, Is this possible for a page to google sheet? Or only as a Notion database to Google Sheets? Have a specific need. Thnks for replying
Hi Sunit! Unfortunately it is design specifically to work with pages inside a database and not regular pages, but please contact us at notion2sheets.com/contact to tell us more about your use case!
you are a superstar!!
Thanks for sharing mate! Waiting for 2 way sync as well😍
Thanks! We are starting a private beta for 2 way sync, contact us and we can add you to the private beta group of users!
What’s the status of the 2 way sync?
this is amazing thanks for sharing it, does it sync both ways? Meaning if I change something in Google Sheets will that show in Notion? thanks!
Hi Santi! Thanks for your comment! For now it is only Notion -> Sheets, but we are thinking about the best way to implement two way sync as well :)
@@LeanZubrezki Amazing, I'll definitely keep an eye of this awesome project. Keep up the great work!