Save links from labeled emails to Google Sheets

Are you tired of digging through your emails to find important links and resources? With this playbook, you can streamline the process and easily extract links from emails with a specific tag.

Whether you're a busy professional trying to stay organized or simply looking for a more efficient way to manage your email inbox, this automation can be a game-changer. By saving the extracted links to a Google Sheets spreadsheet, you can create a centralized database of all your important resources.

This playbook can be especially useful for those who have received a lot of links in the past or have sent themselves links to resources and now want to access them from a database. Instead of spending time searching through your email history, you can quickly and easily access the information you need.

Overall, this playbook can be a valuable tool for anyone looking to save time and streamline their email management process. Give it a try and see how it can transform the way you access and manage your important resources!

Let’s set it up!

Step 1: Pin the playbook and integrate Google Sheets and Gmail

First, click the “Pin it” button at the top of this page to save this automation. You will be redirected to install the browser extension when you run it for the first time. Bardeen will also prompt you to integrate Google Sheets.

Activate Bardeen (or hit OPTION + B on your keyboard) and click to run the playbook. Click on the playbook card, and the setup flow will start. Bardeen will ask for the email label and a Google Sheets spreadsheet to save the information. You can choose an existing sheet or create a new one.

The automation will find all your emails with a specific label, extract the links from the body text and save them to Google Sheets along with the email information like date, body text, subject line, sender address and more.

If there are multiple links in an email, it will create a new row in Google Sheets for each link.

Click on “Save Input” and checkmark Google Sheets. You can edit Inputs later by hovering over the playbook. 

Step 2: Run the playbook to save links from labeled emails to Google Sheets

Press Option + B on your keyboard to launch Bardeen. Click on the playbook card. Run the playbook for a specific label. It will extract all the links from the body text and save the information to your Google Sheets spreadsheet, along with the email information like subject line, date, sender and body text. 

You can also edit the playbook and add your next action to further customize the automation.

Find more Google Sheets integrations, Gmail integrations or explore Google Sheets and Gmail integrations.

 You can also find more about  how to increase your personal productivity.