Miscellaneous general questions and answers about Google Sheets.
Articles Tagged: Google Sheets
Google Sheets tutorial: How to use to automatically create a new sheet with data from rows matching your query
Here are the instructions on how to automatically create separate sheets with data from rows matching your query. The sheet will be created using Google Apps Script and populated using Google Sheets’ FILTER function. This efficient approach ensures that any changes made to the main sheet’s data are automatically reflected in the individual sheets.
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 […]
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 […]
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.
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 […]
Google Sheets tutorial: How to use Google Sheets FILTER formula to populate multiple sheets based on a criteria
The Google Sheets FILTER formula can be used to populate multiple sheets with filtered data based on specific criteria. To do this, you must first create a source sheet with a consistent structure and header row, containing the data you want to filter and distribute to other sheets. Next, create the destination sheets with the same structure as the source sheet, including a header row and the same number of columns.
Google Sheets tutorial: How to hide columns in Google Sheets
This short note explains how to hide columns in Google Sheets
Google Sheets tutorial: How to save Google spreadsheet as a Excel spreadsheet or as a CSV file
How to export or save Google spreadsheet to a CSV file
Google Sheets tutorial: Using BYROW and LAMBDA functions
BYROW and LAMBDA are functions can perform complex calculations and transformations on data. This support note explains how.