Fun with Google Sheets API

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.

How to update a Data Extension in ExactTarget with PHP

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.

Subscribe to API