Home » Archive

Articles in the Google Category

Google, PHP »

[10 Oct 2017 | Comments Off on PHP: Get Timezone & Time Difference from Latitude & Longitude using Google Maps Time Zone API]

This article shows how you can get TimeZone name and id in PHP from latitude and longitude value by using Google Maps Time Zone API.
Note that: You need to put your API Key in the maps api url like this:
https://maps.googleapis.com/maps/api/timezone/json?location=$latitude,$longitude&timestamp=$time&key=xxxxxxxxxxxxxxxxxxxxx

Google, Javascript »

[3 Oct 2017 | Comments Off on Google Maps: Get Latitude/Longitude value on Click and on Mouse Move]

This article shows how to get latitude and longitude value when you click or move the mouse over Google Map.
In previous article, we had seen how we can Display Google Map with Marker when we have latitude and longitude value.

Google, Javascript »

[26 Sep 2017 | Comments Off on Google Maps: Create New Marker on Clicking the Map]

This article shows how to create a new marker whenever you click or double click on the Google Map.
In previous article, we had seen how we can Display Google Map with Marker when we have latitude and longitude value.
Here, we will be using the same code and adding a new functionality of displaying a new marker whenever users double click on the map. You can also add this functionality on “single click” instead of “double click” event. I will be showing both in the example code below.

Google, Javascript »

[19 Sep 2017 | Comments Off on Display Google Map with Marker using Latitude & Longitude Coordinates]

This article shows how you can generate Google Map and display it in your webpage when you have latitude and longitude coordinates value.
We will be using HTML and Javascript to display the Google Map.

Google, PHP »

[12 Sep 2017 | Comments Off on PHP: Get Latitude/Longitude using Google Maps API]

Here is a quick PHP code to fetch latitude and longitude of any given place using Google Maps API.
CURL is used to fetch data from the API URL.

Hope this helps. Thanks.

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 | 11 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.