Friday 7 March 2014

URLs That Every Google User Should Know


URLs That Every Google User Should Know


where can you get a list of every ad that you have clicked on Google? Where should you go if you don’t remember your administrator password? What are your interests as determined by Google?

Here are 10 important links that every Google user should know about. They are tucked away, somewhere deep inside your Google dashboard.
1. Create a new Google Account using your existing email address. The regular sign-up process uses your @gmail.com address as your Google account username but with this special URL, you can use any other email address as your username.
2. Google creates a profile of yourself based on the sites you visit, your Google+ account and other signals. They try to guess your age, gender and interests and then use this data to serve you more relevant ads. Use this URL to know how Google sees you on the web.
3. Google lets you export all your data out of the Google ecosystem. You can download your photos, contacts, Gmail messages and even your YouTube videos. Head over the the Takeout page to grab the download links.
4. If you ever find your content appearing on another website that is using one or more Google products – say Blogger, AdSense, Google+ or YouTube - you can raise a DMCA complaint with Google against that site to get that content removed. This wizard can also be used to remove websites from Google search results that are scraping your content.
5. Your Android device may be reporting your recent location data and velocity (are you moving and if yes, how fast are you moving) back to Google servers. Head over to the Google Maps website to see your entire location history and you also have the option to export this data as KML files that can be viewed inside Google Earth or even Google Drive.
6. Google records every search term that you’ve ever typed into their search boxes. They even keep a log of every ad that you have clicked on various Google websites.
Google URLs
7. You need to login to your Gmail account at least once every 9 months else Google may terminate your account according to their program policies.
This can be an issue if you have multiple Gmail accounts so as a workaround, you can setup your main Gmail account as the trusted content for your secondary accounts. Thus Google will keep sending you reminders every few months to login to your other accounts. Not available for Google Apps.
8. Worried that someone else is using your Google account. Go to the activity report to see a log of every device that has recently been used to log into your Google account. You also get to know the I.P. Address and their approximate geographic location. Unfortunately, you can’t remotely log out of a Google session.
9. This is a complete list of web apps, browser extensions, Google Scripts and mobile apps that have any read or write access to your Google data. If the permission level says “access to basic account info”, it basically means that you have used your Google account to sign-in to that app.
10. This is important URL for Google Apps users. If your Google Account ever getshacked, use this secret link to reset your admin password. You’ll be asked to verify your domain name by creating a CNAME record in your DNS.
https://admin.google.com/domain.com/VerifyAdminAccountPasswordReset
[*] Replace domain.com in the above URL with your own web domain name.
thanks amit agarwal & ajit thakur

Create Direct Links to your Files on Google Drive


Create Direct Links to your Files on Google Drive

by amit agarwal 
      ajit thakur


you can upload files of virtually all types to your Google Drive – from documents to movies to zip archives – and people with whom you have shared the file can easily view them in the browser itself. The Google Docs web viewer is pretty capable and can render all the popular formats including Photoshop files and AutoCAD drawings.


That’s a useful feature but sometimes you may want to bypass the built-in Google Docs viewer and force the browser to download the file instead of opening it. Thus if a user has Photoshop on their computer, the PSD file that you have shared through Google Drive will open in Photoshop and not in their web browser.
Google Drive will mostly render shared links in the browser but you can change that.
Google Drive will mostly render shared links in the browser but you can change that.

Create Direct Links and Skip the Web Viewer

Google Drive doesn’t offer a simple option for creating these “direct download” link but you can easily create them by slightly modifying the generated URLs. Here’s the trick.
A file hosted on Google Drive has a shared link that looks like this:
https://drive.google.com/file/d/FILE_ID/edit?usp=sharing
When you access this link, it will render the file in the browser but if you can rewrite this URL slightly, the link, when clicked, will download the corresponding file in the user’s browser instead of opening it in the browser. The modified URL would be:
https://drive.google.com/uc?export=download&id=FILE_ID
All you have to do is make note of the FILE_ID in the original URL and use it in the modified URL. For example, here’s an image file hosted on Google Drive that will open in the browser and here’s the modified URL that forces the browser to download the file.

Direct Download Links for Google Documents

The trick works for native Google Documents too though the URL format is a little different.
Google Docs: When you share a Google document, the URL would be:
https://docs.google.com/document/d/FILE_ID/edit?usp=sharing
Replace /edit with /export and add the file format that the document should be saved as and your download link is ready.
https://docs.google.com/document/d/FILE_ID/export?format=doc https://docs.google.com/document/d/FILE_ID/export?format=pdf
The above links will now download the same Google document in Word (.docx) and PDF formats. You can also use “txt”, “html” and “odt” for the download format.
Google Presentations: Google Docs offer an even simpler URL scheme for creating direct links to Google Presentations. The original shared links are of the following format:
https://docs.google.com/presentation/d/FILE_ID/edit?usp=sharing
The direct links for downloading the same presentation deck in PowerPoint (.pptx) and PDF formats are below:
https://docs.google.com/presentation/d/FILE_ID/export/pptx https://docs.google.com/presentation/d/FILE_ID/export/pdf
Google Spreadsheets: Open your Google Spreadsheet in the browser, make the sheet Public (or Anyone with a link) and make a note of the shared URL. It should be something like this:
https://docs.google.com/spreadsheets/d/FILE_ID/edit?usp=sharing
The direct download links use a similar format as Google Documents and will read like:
https://docs.google.com/spreadsheets/d/FILE_ID/export?format=xlsx https://docs.google.com/spreadsheets/d/FILE_ID/export?format=pdf

Bonus Trick – Make a Copy

Google Spreadsheets offers an additional feature that is not available in Documents and Presentations (at least yet). You can create links to Google Sheets that will automatically create a copy of your Google Sheet in the Google Drive of the person with whom you have shared the sheet.
Before: https://docs.google.com/spreadsheets/d/FILE_ID/edit?usp=sharing After: https://docs.google.com/spreadsheet/ccc?key=FILE_ID&newcopy=trueThe newcopy=true parameter did the trick.
thanks to amit agarwal & ajit thakur