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.
All posts by cloudhqsuppo3
How to edit Gmail templates inside Gmail composer using HTML editor
If you need to edit the HTML of the template (for example, to modify image, add a table, change fonts, etc.) then you can use HTML editor directly inside Gmail compose window. Here is how to do it: Compose your email and click the “Insert Template” button on your Gmail to select from pre-made or customized […]
How to edit and modify Gmail templates in Google Drive
Your Gmail templates are stored in your Google Drive folder called Gmail Templates. You can edit these templates directly from your Google Drive – there is no need to open Gmail composer (as described here) Here is how to do it: Go to your Google Drive Click on “My Drive” and open Gmail Templates folder: […]
Google Sheets tutorial: How to change timezone of the Google Spreadsheet
When you change the time zone of a spreadsheet, it changes the spreadsheet’s default dates to be shown in your specified timezone. On your computer, open a spreadsheet in Google Sheets. Click File and then Settings. Under General, click the Time zone menu to change your settings. Click Save settings.
Email Tracker: How to set up an email reminder if your email message is not opened in 2 days
NOTE: Instructions on how to install Free Email Tracker are here. Free Email Tracker provides an option to receive an email reminder if recipient does not open your email message in 48 hours. You can set up that reminder per message or you can set up default that all sent messages have the reminder. Here […]
Email Tracker: How to set up an email reminder if there is no reply in 2 days
Free Email Tracker provides an option to receive email reminder if a recipient does not reply to your email in 48 hours.
What is a tracking pixel and can strangers really spy on me through email?
Tracking pixels (also called web beacons, web bugs, tracking bugs, web tags, page tags, pixel tags) are small 1 x 1 GIFs which are embedded in emails by marketers and some email companies to track the following: when did you open your email where did you open your email how many times did you open […]
Google Sheets tutorial: Import the data from multiple Google Spreadsheets into the one
Some examples of how to parse cells using Google Sheets formulas and functions
How to turn on conversation view in Gmail?
Open Gmail. Click the gear in the top right. The setting panel will open. Scroll all way down and you will see Conversation view checkbox. Tick it: Once you have done this, you should see the email in the threaded view. You can switch back anytime if you prefer the conversation view to be off.
Google Sheets tutorial: How to create a new Google sheet (tab)
Some examples of how to parse cells using Google Sheets formulas and functions