Home » Archive

Articles in the Google Category

Google AppScript »

[20 Mar 2017 | Comments Off on Google AppScript: Create Form using HTML, Publish Form as WebApp & Show data from Spreadsheet]

This article shows:
1) How to create Google Form using standalone HTML file
2) Fetch data from Google Spreadsheet and populate Select box of the HTML Form
3) Populate second select box based on the value selected from first select box
4) Show result data from spreadsheet on form submit
Basically, we have a spreadsheet that contains exam marks obtained by students of different grades/classes.

Google AppScript »

[6 Mar 2017 | Comments Off on Google AppScript: Create Form using HTML, Publish Form as WebApp & Email Response]

This article shows:
1) How to create Google Form using standalone HTML file
2) Email form submitted data to any particular email address
Create HTML file

Google AppScript »

[27 Feb 2017 | Comments Off on Google AppScript: Create Form using FormApp class, Publish Form as WebApp, Email & Save Responses to Spreadsheet]

This article shows:

1) How to create Google Form using AppScript’s “FormApp” class
2) Send Form URL to any email address using MailApp or GmailApp class
3) How to use Triggers in AppScript
4) How to send Form submit Responses to any email address
5) How to save Form submit Responses to any particular Google Spreadsheet
Create Google Form and email the Form URL

Google AppScript »

[20 Feb 2017 | Comments Off on Google AppScript: Get Latitude Longitude & Distance between Places/City]

This article shows how to get latitude and longitude of a particular place or city. We read the city/place name from a Google Spreadsheet, then get the latitude and longitude of that place using Google AppScript’s “Maps” class and then save the lat long in the spreadsheet.
We will also be reading two places name from a Google Spreadsheet and then get the distance between those places in Kilometer using AppScript’s Maps class. Then, we save the distance in the spreadsheet.

Google AppScript »

[13 Feb 2017 | Comments Off on Google AppScript: Send Multiple Emails by reading data from Spreadsheet]

This article shows how to read list of email addresses, subject and message body from Google Spreadsheet and send separate emails to all of them with Google AppScript.
First, let’s see a simple example of sending single message to a particular email address.

Google AppScript »

[6 Feb 2017 | Comments Off on Google AppScript: Create and Write to Google SpreadSheet]

This article shows how to create a new Google Sheet and write data into it with Google AppScript. We will also be writing data into existing Google SpreadSheet.
Create a new Google Sheet and write data into it with AppScript

Google AppScript »

[30 Jan 2017 | Comments Off on Google AppScript: Creating File, Folder & Google Doc]

This article shows how to create a new folder and file with some text inside it with Google AppScript. We will also see how to create a new Google Doc and write some text inside it through AppScript.
Create File & Folder with AppScript

Google AppScript »

[23 Jan 2017 | Comments Off on Google AppScript: Basic/Beginner Introduction [TUTORIAL]]

This tutorial provides a very basic introduction to Google App Script. I will also list out the works that can be done with AppScript. And, I will be showing very basic Javascript code that can be run on AppScript’s console. In this article, we will be dealing only with Javascript arrays and loops.
What is Google AppScript?

Google, Social Media »

[15 Jan 2016 | Comments Off on Google Social Connect: Redirect URI mismatch error]

Scenario:
I have setup Google Social Connect on a website. When I try to login through Google Social Connect, I get the following 404 error stating:
Error: redirect_uri_mismatch
The redirect URI in the request: http://MY-WEBSITE-URL/socialconnect/google/connect/ did not match the registered redirect URI.

Google, PHP »

[15 Aug 2015 | 10 Comments]

I was using ClientLogin method to access and update Google Spreadsheet. The ClientLogin method was in a deprecated state and now it has been turned off. We now need to use OAuth for authentication.
Google APIs Client Library for PHP enables you to work with Google APIs such as Google+, Drive, or YouTube on your server. In the example code below, I am using version 1.1.4 of this library.

Google, Magento »

[18 Mar 2013 | Comments Off on Magento: Google Analytics not working after Magento upgrade to version 1.7]

Problem:- I recently upgraded a Magento shop from version 1.6 to 1.7 and suddenly the Google Analytics stopped tracking data.
Solution:- You need to add ‘template’ attribute to googleanlytics block in app/design/frontend/your_package/your_theme/layout/googleanalytics.xml

Google, Making Money Online »

[17 Jul 2012 | 4 Comments]

Google Adsense is a very popular program for earning money online. Google Adsense generate revenue on either a per-click or per-impression basis.
In this article, I will be describing some of the key terms of Google Analytics. They are Clickthrough rate (CTR), Cost-per-click (CPC), Cost-per-thousand (CPM), and Revenue per thousand impressions (RPM). Before understanding these terms, we need to know about the following basic terms:

Google, Magento »

[5 Jun 2012 | Comments Off on Magento: Solution for Google Analytics not tracking website]

I had an old version of Magento. I had enabled google analytics tracking from Magento admin. But, google analytics was not tracking my webshop.
The main reason behind this was that Google had modified its analytics tracking code and the GoogleAnalytics core module of Magento had old tracking code.

Google »

[17 May 2012 | 3 Comments]

Problem:
My website/blog had a good visit per day and it was also ranking good on Alexa. However, recently the per day visit has dropped drastically. And, alexa ranking is also dropping gradually day by day.
Cause:

Google »

[15 Aug 2011 | One Comment]

There are some important questions regarding Google Analytics. Information about Unique Visitors, Total Visits, New Visitors, Returning Visitors, Unique Visitors, Absolutely Unique Visitors, Pageviews, and Unique Pageviews might be confusing and need clarification. I had such questions and issues. I googled them and found answers to some important queries for Google Analytics (GA). Here they are:-
1. Unique Visitors are higher than Total Visitors in custom reports