Putting Value in the spreadsheet through Google App script
function myFunction()
{
var ss=[Link]();
var sheet=[Link]();
var range=[Link]('A1');
[Link]('Hello')
}
SEND TEST E-MAIL
function myFunction() {
var ss=[Link]();
var sheet=[Link]();
var range=[Link]();
var values = [Link]();
[Link]('[Link]@[Link]', 'test mail', 'test');
}
SEND TEST E-MAIL BY EXTRACTING DATA FROM SPREADSHEET
function myFunction() {
var ss=[Link]();
var sheet=[Link]();
var range=[Link]();
var values = [Link]();
var email=values[1][0];
var subject= values[1][2];
var body=values[1][3];
[Link](email, subject, body);
}
SENDING EMAIL TO MULTIPLE PEOPLE
function myFunction() {
var ss=[Link]();
var sheet=[Link]();
var range=[Link]();
var values = [Link]();
for(i=1;i<[Link];i++)
{
var email=values[i][0];
var subject= values[i][2];
var body=values[i][3];
[Link](email, subject, body);
}
}
SENDING MULTIPLE TEXT INTO BODY TO EMAIL
function myFunction() {
var ss=[Link]();
var sheet=[Link]();
var range=[Link]();
var values = [Link]();
var email=values[1][0];
var subject= values[1][2];
var data = [Link]('A8:N40').getValues();
var body = '';
for( var row in data ) {
for( var col in data[row] ) {
body += data[row][col] + '\t';
}
body += '\n';
}
[Link](email, subject, body);
LOOPING IN GOOGLE APP SCRIPT
function myFunction() {
var ss=[Link]();
var sheet=[Link]();
var range=[Link]();
var values = [Link]();
for(i=1;i<[Link];i++)
{
var email=values[i][0];
var subject= values[i][2];
var body=[Link]('A1);
[Link](email, subject, body);
}
function runDemo() {
try {
var firstProfile = getFirstProfile();
var results = getReportDataForProfile(firstProfile);
outputToSpreadsheet(results);
} catch(error) {
[Link]([Link]);
}
}
function getFirstProfile() {
var accounts = [Link]();
if ([Link]()) {
var firstAccountId = [Link]()[0].getId();
var webProperties = [Link](firstAccountId);
if ([Link]()) {
var firstWebPropertyId = [Link]()[0].getId();
var profiles = [Link](firstAccountId, firstWebPropertyId);
if ([Link]()) {
var firstProfile = [Link]()[0];
return firstProfile;
} else {
throw new Error('No views (profiles) found.');
}
} else {
throw new Error('No webproperties found.');
}
}
[Link](firstProfile) ;
/*
else {
throw new Error('No accounts found.');
}
*/
}
function getReportDataForProfile(firstProfile) {
var profileId = [Link]();
var tableId = 'ga:59791098';
var startDate = getLastNdays(14); // 2 weeks (a fortnight) ago.
var endDate = getLastNdays(0);
// Today.
var optArgs = {
'dimensions': 'ga:keyword',
'sort': '-ga:sessions,ga:keyword',
// Comma separated list of dimensions.
// Sort by sessions descending, then keyword.
'segment': 'dynamic::ga:isMobile==Yes', // Process only mobile traffic.
'filters': 'ga:source==google',
// Display only google traffic.
'start-index': '1',
'max-results': '250'
// Display the first 250 results.
};
// Make a request to the API.
var results = [Link](
tableId,
// Table id (format ga:xxxxxx).
startDate,
// Start-date (format yyyy-MM-dd).
endDate,
// End-date (format yyyy-MM-dd).
'ga:sessions,ga:pageviews', // Comma seperated list of metrics.
optArgs);
if ([Link]()) {
return results;
} else {
throw new Error('No views (profiles) found');
}
}
function getLastNdays(nDaysAgo) {
var today = new Date();
var before = new Date();
[Link]([Link]() - nDaysAgo);
return [Link](before, 'GMT', 'yyyy-MM-dd');
}
function outputToSpreadsheet(results) {
var sheet = [Link]().insertSheet();
// Print the headers.
var headerNames = [];
for (var i = 0, header; header = [Link]()[i]; ++i) {
[Link]([Link]());
}
[Link](1, 1, 1, [Link])
.setValues([headerNames]);
// Print the rows of data.
[Link](2, 1, [Link]().length, [Link])
.setValues([Link]());
}
------------------------------------------------------------------------------------------------------------------------------------------------wadimcc@[Link]
google@wadi123
LINKING GOOGLE APP SCRIPT TO MYSQL
function runDemo() {
var connection = [Link]("jdbc:mysql://[Link]:3306/wdview", "reporting",
"9lyeplzQl57G");
var SQLstatement = [Link]();
var result = [Link]("SELECT * FROM status_cache");
var ss = [Link]();
var cell = [Link]('A2');
// loop through result object, setting cell values to database data
var row = 0;
while([Link]()) {
for(var i=0; i<4; i++) {
// four fields per record
[Link](row, i).setValue([Link](i+1));
}
row++;
}
[Link]();
[Link]();
[Link]();
}
Clear the contents of the spreadsheet
function runDemo() {
var ss=[Link]();
var x=[Link]();
[Link]();
