UrTrix - UnRevealed Tricks

The Government of India website has a live dashboard that provides, in near real-time, the number of Coronavirus (COVID-19) cases in various states of India. This is the best resource to get updates around active COVID-19 cases in India. COVID-19 Tracker for India The official website provides the current data but if you were to check how the number of confirmed cases increased in India over time, there’s no historic data available. That’s one reason I built the COVID-19 Tracker with Google Sheets. The tracker scrapes data from the official website every few minutes and uses Sparklines to help you visualize how the coronavirus outbreak is spreading in India over time. The Government has been actively publishing reports since March 10 and all the data can also be accessed through the Google Sheet. COVID-19 Sheets Tracker COVID-19 JSON API If you are a developer, I’ve also published the data as a JSON API that will provide you the latest state-wise data of COVID-19 cases a...

The Gmail Mail Merge addon can now import the email addresses of subscribers from your MailChimp mailing lists into Google Sheets. If you wish to send emails to your subscribers directly from Gmail, instead of using MailChimp mail servers, this is the way to go. As a developer, you can use Google Apps Script to import subscriber lists, HTML campaigns, performance reports and any other data from MailChimp to Google Sheets for analysis. You can use the MailChimp OAuth2 library but in this example, we’ll use the developer key directly to connect to MailChimp. Get the MailChimp Developer Key In your Mailchimp account, navigate to the Account page. In the drop-down menu, select Extras, and then API keys. Click Create A Key and make a note of it. Google Apps Script - Get MailChimp Audiences const MAILCHIMP_API_KEY = '<<API_KEY_HERE>>' ; // MailChimp API key includes the data center id // that your MailChimp account is associated with const makeHttpRe...

A friend writes - “Any suggestions on how to combine the Google photo library with iPhoto. Which is a better platform for keeping the photos? Google seems to be very handy in sorting and searching. Would love to know your views” I am a big fan of Google Photos for several reasons - you get unlimited storage space, Google is pretty good at visual image search and you can have collaborative photo albums where multiple people can upload to a common folder. Transfer Photos from Apple iCloud / Mac to Google Photos If you would like to copy your photos from iCloud / Apple Photos to Google Photos, there are no browser plugins or software that can automate this - you’ll have to manually transfer the picture library from Apple to Google Photos. Luckily, that migration process isn’t difficult either. It is a two-step process - you download the photos from iPhoto and iPad to your computer via iCloud and then put them on to the Google Cloud. Let’s see how: Step 1: Download Photos from i...

When Google launched Gmail in 2004, it bundled 40x more free storage space than competing webmail services. It seemed to solve all storage woes and they did not include a “delete” button in Gmail because, with a gigabyte available, why would anyone ever delete their emails. They’ve adopted a similar approach with Google Photos but gone a step further. Google Photos offers unlimited online storage space for your digital photos and videos. The original images are compressed after uploading but the difference is barely noticeable, at least on our mobile and computer screens. I started dumping all my pictures to Google Photos, the day it launched, and couldn’t be happier. The initial purpose was online backup but now Google Photos has become “the” place where I go to explore my photos. The files do not consume a byte of local storage space and yet the entire collection is always available on every device that I own. Here are essential things that you should know about Google Photos and...

How do I contact the owner of a website? Where is a particular website hosted? What other websites are hosted on that same server? Is the site using WordPress or Gatsby? Which ad networks are they using to monetize a site? Is my site accessible from China? Here are some of the most useful online tools that will help you know every single detail of any website. Also see: The Essentials Tools for Programmers just-ping.com — Use Just Ping to determine if a particular website is accessible from other countries. Just Ping has monitoring servers across the world including Turkey, Egypt, and China so if the ping results say 100% Packet Loss, most likely the site is inaccessible from that region. who.is — If you like to know the contact address, email and phone number of the website owner, this free whois lookup service will help. This is a universal lookup service meaning it can simultaneously query the whois database of all popular domain registrars. whoishostingthis.com — Enter the...

The finance team in an organization would like to use Gmail for internal communication only. The corporate email policy restricts the finance team from sharing any files or email messages with external teams but the employees are allowed to exchange emails within the team. Google makes it easy to implement such an email policy in Gmail for GSuite customers. To get started, sign-in to admin.google.com as your GSuite domain admin and go to Apps > GSuite Core Services > Gmail > Advanced Settings. Inside the General Settings tab, navigate to Restrict Delivery and click the Configure button to restrict the domains that your employees are allowed to exchange emails with. Under the Add addresses section, specify one or more domains and email addresses that employees are allowed to send and receive email messages from. You can specify inputs in the following format: harvard.edu - Allow emails from everyone in the domain *.harvard.edu - Allow emails from all subdomains ...

In one of my web projects, I required a simple encryption and decryption JavaScript library that could encode a piece of text and and then decode the encoded string on the server side. The easiest option is the base64 encoding scheme that can be easily implemented in both native JavaScript and Google Apps Script. Base64 Encoding with Google Apps Script const base64Encode = text => { const base64data = Utilities . base64Encode ( text , Utilities . Charset . UTF_8 ) ; return base64data ; } ; const base64Decode = base64data => { const decoded = Utilities . base64Decode ( base64data , Utilities . Charset . UTF_8 ) ; const input = Utilities . newBlob ( decoded ) . getDataAsString ( ) ; return input ; } ; Base64 Encoding with JavaScript const CryptoJS = require ( 'crypto-js' ) ; const encrypt = text => { return CryptoJS . enc . Base64 . stringify ( CryptoJS . enc . Utf8 . parse ( text ) ) ; } ; const decrypt ...