Google Sheets: the 6 most important and advanced formulas

https://www.makeuseof.com/crazy-google-sheets-formulas-extremely-useful/ Creating a spreadsheet by entering a few columns of data and applying the basic functions of mathematics is simply the tip of the iceberg. More utility and automation lies under the ocean of things that you can do on Google Sheets. Whether for work, school, or home, you can use Google Sheets in many […]

Read More

How do I merge two worksheets into one?

For example, we have two jobs exporting email messages from particular labels into two different Google Sheets, as shown in the cloudHQ dashboard The cloudHQ jobs create two existing spreadsheets for exporting emails: label Name label Test Firstly, we need to create a destination Google Sheet named “SpreadsheetMerge” manually: Secondly, we use the IMPORTRANGE function […]

Read More

Wizard to export emails to Google Sheets

Backup email messages from a Gmail label This wizard will help you set up a continuous backup of all your emails of a Gmail label and save them in your Google Sheets. All of your attachments will also be saved as a PDF Google Drive link in your Google Sheet. This is an excellent solution […]

Read More

Use case: Automatically find all bounced email messages and parse them (‘Delivery Status Notification’, ‘failure notice’, etc.)

The Export Emails to Google Sheets application offers a unique Automatic Bounced Email Detection feature, that identifies and records invalid email addresses in real-time to a Google Sheet. This feature boosts the success rate of your email campaigns and sender reputation by eliminating bounced emails from your lists, making it a vital tool for small businesses and individuals running email marketing campaigns.

Read More

Email parsing: How to parse tables in email messages

Sometimes, data you need to extract from your email message is formated as a table. For exmaple, your email messaage can look like this: When you open parsing editor to parse this email you will see tab called Tables. To extract this table, click on Tables and just hightlight table columns: Automatically find all bounced […]

Read More