Send fax for free using google docs addon:

https://chrome.google.com/webstore/detail/faxplus-fax-your-document/mengopodcmfgfjphedcfhokajmmappjm?hl=en

#fax #faxplus #google #google_docs

Did you know you can syntax highlight your codes in google docs using an add on?

This is code block! An addon that adds syntax highlighting to your documents. In order to download it, go to Add-ons menu in google docs and click on Get add-ons. Search for code block and install it.

After installation Code Block option will be added to Add-ons menu. Click it and hit Start. Now you will have a great syntax highlighting right in your toolbox. :)

Happy syntax highlighting! :D

#google #code #syntax_highlight #code_block #addon #google_doc

#google_doc #code_block #addon

#Google on #valentine.

#podcast #audio #part6 #google #alphabet

#podcast #part12 #google #vmware #greene

If you have installed google-api-python-client and got below error on authentication:

No crypto library available

You need to install PyCrypto using pip or PyOpenSSL.

You can also do:

sudo pip install PyOpenSSL --upgrade

#python #google_api_python_client

https://www.cagrimmett.com/til/2016/07/07/autofill-google-forms.html

#google #google_forms #prefill #prefill_google_forms

Send Google Forms to Slack

# read more about slack web hooks here: https://api.slack.com/incoming-webhooks

 var POST_URL = "https://hooks.slack.com/services/YOUR_TOKEN";

 function onSubmit(e) {
   var response = e.response.getItemResponses();

   var toType = function(obj) {
     return ({}).toString.call(obj).match(/\s([a-zA-Z]+)/)[1].toLowerCase()
   }

   // "Form Respondent: " + e.response.getRespondentEmail()

   var email = response[0].getResponse();
   var field2 = response[1].getResponse();
   var field3 = response[2].getResponse();
   var field4 = response[3].getResponse();

   var d = "*SUBMITTED FORM*\n>>>Email: " + email + "\n";

   d += "other fields: \n" + field2 + field3 + field4;

   var payload =
       { "payload": '{"text": "' + d + '"}' }

    var options =
    {
      "method" : "post",
      "payload" : payload
    };

    UrlFetchApp.fetch(POST_URL, options);
 };

You need to add javascript code above to Script Editor section of google form. When you are in form editing mode click the three dot in top corner and click on Script Editor. When your're done click on save and give a name to your project script. Now on the script editor page click on edit -> All your triggers and bind your script to form onSubmit event.

Read more about webhooks for slack here:
- here: https://api.slack.com/incoming-webhooks

That's all! Now will have all your submitted forms in Slack. Voila!

#google #slack #forms #google_forms #webhook #hook #javascript

How to query on Google Big Query?

Big Query or for short BQ is a data warehousing solution that puts your data on a serverless platform with no limit on data size and processing power. It is design for this specific purpose and returns aggregated results in a fraction of a second most of the time.


In python you can use its library by installing google-cloud-bigquery:

pip install --upgrade google-cloud-bigquery

Now create a service account as stated in link below:

https://cloud.google.com/bigquery/docs/reference/libraries

We assume that you have done the installation and configuration process for now. To query on BQ:

from google.cloud import bigquery
 bigquery_client = bigquery.Client()
 dataset_id = 'MY_PROJECT'
 query = ("SELECT user_id FROM MY_PROJECT.users LIMIT 100")

 # API CALL
 query_job = bigquery_client.query(query)

 for row in query_job:
     print row.user_id, row['user_id']

You can send update commands like the above query too.

#google #BI #bigdata #bigquery #warehouse #data_warehouse