Unexpected Web

Create new google spreadsheet if sheet exist in my spreatsheet

By ABONZERTV

Read

1 Comments

Create custom dialog box or Html Popup in google app scripts

By ABONZERTV

Read

0 Comments

Create Navigation Tabs using HTML, CSS, JS

By ABONZERTV

Read

0 Comments

Vertical Tabs HTML Code

Vertical Tab Example :

https://www.w3schools.com/w3css/tryit.asp?filename=tryw3css_tabulators_sidenav

Our Code: https://jsfiddle.net/abonzer/etsbu4pm/

<!DOCTYPE html>
<html>
<head>
<style>

body {
    font-family: Verdana,sans-serif;
    font-size: 15px;
    line-height: 1.5;
    margin: 0;
}

h2 {
 font-style: oblique;
    font-weight: 400;
    margin: 10px 0;
    font-size: 20px;
 font-family: "Segoe UI",Arial,sans-serif;
}

div {
    display: block;
}

.red {
 color:#fff!important;
 background-color:#f44336!important;
 
}


.sidenav a { 
   text-decoration:none!important;
   padding: 4px 2px 4px 16px;
   display:block;
   
}


.sidenav{
 height:100%;
 width:200px;
 color: #000!important;
    background-color: #f1f1f1!important;
 position:fixed!important;
 z-index:1;
 overflow:auto;
 padding:4px 2px 4px 16px;
 box-shadow: 0 2px 4px 0 rgba(0,0,0,0.16),0 2px 10px 0 rgba(0,0,0,0.12)!important;
}
.sidenav a:hover {
 background-color:#ccc;
 color:#000;
}


</style>
</head>


<body>

<nav class="sidenav" style="width:160px">
  <div style="padding:0.01em 16px;">
    <h2>Email Tracker</h2>
  </div>
  <a href="javascript:void(0)" class="tablink" onclick="openCity(event, 'How to use')" style=" color: #333333;">How to use</a>
  <a href="javascript:void(0)" class="tablink" onclick="openCity(event, 'Track Mail')" style=" color: #333333;">Track Mail</a>
  <a href="javascript:void(0)" class="tablink" onclick="openCity(event, 'Tracking ID')" style=" color: #333333;">Tracking ID</a>
</nav>

<div style="margin-left:160px">
  

  <div id="How to use" class="city" style="padding: 8px 72px!important; display:none;">
    <h2>How to use Email Tracking Feature</h2>
    <p>London is the capital city of England.</p>
    <p>It is the most populous city in the United Kingdom, with a metropolitan area of over 13 million inhabitants.</p>
  </div>

  <div id="Track Mail" class="city" style="padding: 8px 72px!important; display:none;">
    <h2>Track Email Read Receipts</h2>
    <p>Paris is the capital of France.</p> 
    <p>The Paris area is one of the largest population centers in Europe, with more than 12 million inhabitants.</p>
  </div>

  <div id="Tracking ID" class="city" style="padding: 8px 72px!important; display:none;">
    <h2>Add your Analytics ID</h2>
    <p>Tokyo is the capital of Japan.</p>
    <p>It is the center of the Greater Tokyo Area, and the most populous metropolitan area in the world.</p>
  </div>

</div>

<script>
function openCity(evt, cityName) {
  var i, x, tablinks;
  x = document.getElementsByClassName("city");
  for (i = 0; i < x.length; i++) {
     x[i].style.display = "none";
  }
  tablinks = document.getElementsByClassName("tablink");
  for (i = 0; i < x.length; i++) {
      tablinks[i].className = tablinks[i].className.replace(" red", "");
     
  }
  document.getElementById(cityName).style.display = "block";
   
    evt.currentTarget.className += " red ";
}
</script>

</body>
</html>

How to Import mail Subject and message from gmail into Spreadsheet

By ABONZERTV

Read

0 Comments

Learn how Save Gmail Messages Subject and message to a Google Spreadsheet using Google Apps Script.

You are trying to transfer gmail message subject and body content into google sheets or microsoft Excel ? Well I am build a simple script using Google Apps Script that would export subject lines and message body of up to the first 500 emails in your Inbox.

Max first 500 messages are to be saved at once using this Script. To get started, open Google Sheet and go to Tools > Script Editor.. , paste the code in the script editor of a Google Spreadsheet and run any of these functions according to your requirement from the Run menu.

Save Email Subjects :

function importSubject() {
  // Log the subject lines of up to the first 50(change up to 500) emails in your Inbox
 var threads = GmailApp.getInboxThreads(0, 50);
 var subno = 'A'; // Select column
  var j=1; //counter for row no
  
  for (var i = 0; i < threads.length; i++) {
   
   subno = 'A' + j;// generate cell address
   SpreadsheetApp.getActiveSheet().getRange(subno).setValue(threads[i].getFirstMessageSubject());//get the subject of threads[i]
    j++;
 }
}

Save Email message Content/Body in plane Text :



function importMessage() {
  // Log the subject lines of up to the first 50 emails in your Inbox
 var threads = GmailApp.getInboxThreads(0, 50);
 var subno = 'B';
  var j=1;
  for (var i = 0; i < threads.length; i++) {
      subno = 'B' + j;
     var message = threads[i].getMessages()[0];  // get first message of thread[i]
   SpreadsheetApp.getActiveSheet().getRange(subno).setValue(message.getPlainBody());// get message body in plain text (not in html code) of threads[i]
    j++;
 }
}

Save Email Subject and message Content/Body in plane Text :

function importSubjectAndMessage() {
  // Log the subject lines of up to the first 50 emails in your Inbox
 var threads = GmailApp.getInboxThreads(0, 50);
 var subno = 'A'; // Select column
  var msgno = 'B';
  var j=1; //counter for row no
  
  for (var i = 0; i < threads.length; i++) {
   
   subno = 'A' + j;// generate cell address
    msgno = 'B' + j;
   SpreadsheetApp.getActiveSheet().getRange(subno).setValue(threads[i].getFirstMessageSubject());//get the subject of threads[i]
     var message = threads[i].getMessages()[0];  // get first message of thread[i]
   SpreadsheetApp.getActiveSheet().getRange(msgno).setValue(message.getPlainBody());// get message body in plain text (not in html code) of threads[i]
    j++;
 }
}