Hello,
I have inquiry that is too long to tweet, too technical for facebook, and I wouldn't know who to email it to. So I'm posting it here as a gist in the hope that it can reach someone who might have an answer or suggestion to the problem I'm trying to solve.
The problem is this: I have a Google Apps script scraping for content to add to amillionbluepages.net. I'd like for it to tweet whenever it finds and ingests something new, but I don't know how to make that work reliably.
For now, and this isn't working, I compose a tweet text in the script, append that text as a cell on a google spreadsheet, and then I have an If This Then That recipe checking the RSS feed generated by that spreadsheet. The problem is, IFTTT can't always read those new cells because Google Spreadsheets doesn't output consistent or valid RSS. I'm not sure what's going on there.
The other option I know of would seem to be easier: send tweets directly from the Google Apps script. That would be great, except for a Google Apps bug that breaks authentication when you use certain characters. Until that bug gets fixed, it's not a realistic option.
So I'm not sure what to do here. I could probably rig something up with the JSON output to a Yahoo Pipe, but that's just so many steps I'd rather avoid. Surely there's an easier way? Is there a service or solution I'm forgetting that could help?