The scripting in Google drive is pretty awesome. I saw some pretty impressive automation recently that a business analyst did where he'd grab spreadsheet attachments to emails in Gmail and analyze them in sheets.
These are all real problems I've had to work around.