I've been playing around with the Google Sheets API to automate some mundane pages. I can't really take credit for figuring out the connection in version 3 of the API. That credit goes to Karl Kranich. From what I can tell, this version was short lived and seems experimental. Just as I got this working Google releases the version 4 API and says we should all use that.... Oh well, I'll move on to that one on my next project, this is already done for now.

I recently had to create a page with 20+ slideshows. I was translating the page from a WordPress site. The original page builder had used the WordPress built in slideshow, which is easy, but did not do him any favors in terms of performance. The page loaded all the slideshows at once and when they got going, you could really feel the page bog down.

Here is a handy little script I recently wrote to automate a monotonous task in Acrobat.

Since Acrobat has no method of actually changing field types, you have to remove all fields and add new ones in place. This script gets the coordinates of the existing fields and replaces them in exactly the same spot with new fields.

ExactTarget's documentation leaves something to be desired... It took me a while to figure this out, and it came mostly out of trial and error or other users like me who posted tutorials. So I wanted to pay it forward by posting my experience here, in hopes that it will help someone. The tutorial is below, but the entire directory is also available in my downloads section, at the bottom of this page, or in my github repository.