General Musing

blaze your trail

Posts Tagged ‘googledocs

Create Documents from GMail Conversations #blogging

leave a comment »

Using GMail daily I hadn’t noticed the item Create a document in the menu before yesterday, I decided to try it out and I really like it. The function allow you to turn an entire conversation into a document which is stored into Google Docs with the push of a button.

GMail menu

The quoted text contains all the included markup, altough it doesn’t include the sender details, it removes all the quoted text it recognizes. What it doesn’t do is truncate the text below the “sig dashes” (“signature cut line”, “sig-marker”, or “sig separator”), which is what I expected.

I create many post based on conversations I see on mailing lists, or other place. This feature makes it easier to collect all the text of the conversation, as the sender is not included it is necessary to through source text to attribute the quotes to the correct person.

Nice feature!

Image source: VentureBeat, me

Advertisements

Written by Daniël W. Crompton (webhat)

March 28, 2012 at 8:40 pm

Posted in blogging, mail

Tagged with , , , , ,

HootSuite Auto Scheduling using Google Docs #twitter

with one comment

I like using the HootSuite bulk uploader, and round the time I posted the post HootSuite Bulk Uploads I had set up a Google Docs file to produce the csv file it requires as input. It can simply be made by uploading the example provided by HootSuite to Google Docs and using that as a template.

Google Documents Validation

As I was explaining the features of HootSuite to my mother, including the bulk uploader, I suddenly realized that I could make my spreadsheet more valuable for myself and others by adding a check to see whether it has 140 characters. I wasn’t able to use the regular Docs Data Validation, so I decided to roll my own in the script editor, which meant adding a Trigger to the script so it is called after the spreadsheet is edited. Read the rest of this entry »

Written by Daniël W. Crompton (webhat)

February 26, 2012 at 9:53 pm

Proof of Concept: Google Docs Mail Merge Form with Text and HTML #wordpress

with one comment

I needed a way to be able to shamelessly plug the posts I recently bundled into the booklet “Write Something” again.In a similar way to the last time I did it in Proof of Concept: Google Docs Mail Merge Form

As I explained before I have set up a system to automatically mail somebody when the enter their address in the form, my issue was that I wanted to add a unique blogpost which they would only be able to get by signing up. Naturally I wanted to style it in the same way the posts are styled in this blog. Again I turned to the documentation, specifically the Class MailApp which I was using to send the mail. Using this documentation I had a starting point. I wanted three changes to the current script:

  1. keep the plain text
  2. add HTML message
  3. add inline images

Read the rest of this entry »

Written by Daniël W. Crompton (webhat)

February 24, 2012 at 12:50 pm

Proof of Concept: Google Docs Mail Merge Form #wordpress #updated

leave a comment »

I needed a way to be able to shamelessly plug the posts I recently bundled into the booklet “Write Something“. I want to build a list, and offering something which adds value for the subscriber is a good way to do this. There is a host of good material which you can use to help, so I won’t elaborate on that in this post.

I have a hosted WordPress.com blog, which means that I can’t run a local script to collect the mail addresses and mail them, so I turned to Google Docs’ Form functionality for the entry form, naturally I give them the option to download the booklet there, and I wanted to send the subscriber a message to thank them. In the Google tutorial: Simple Mail Merge they explain how to do a mail merge using the Script Editor. I wanted to go a little further and have it send a mail with thank you note and a link to each subscriber as soon as they filled in the form.

Read the rest of this entry »

Written by Daniël W. Crompton (webhat)

January 23, 2012 at 9:59 pm

%d bloggers like this: