3 ms·
I automate everything I can! But maybe if I have to recommend one way, I would recommend Google Spreadsheets scripts. Similar to Visual Basic for Applications i
by jgimenez 8y ago
I automate everything I can! But maybe if I have to recommend one way, I would recommend Google Spreadsheets scripts. Similar to Visual Basic for Applications in Excel, Google Spreadsheets support Javascript and you can use them for infinite things.
Some things we use them for:
* automate the bank payments to our suppliers (exporting the table format in SEPA XML format)
* tweet some of our evergreen blog posts every day (note these scripts run in the cloud, the spreadsheets do not even need to be open)
* assist in the formatting of our newsletters (we write sections in Markdown, the script formats and uploads images to our blog, uploads the finished article and schedules)
We also use Zapier extensively. One particular automation I'm really proud of is accounting: we use Zapier to collect invoice PDFs sent by email, later on I wrote some scripts using Selenium to also log in and download invoices from websites that do not send the PDF over email. This saved me tons of time. Then a small script downloads the bank statements and puts each line in an Asana task, this way I can do reconciliation: I find the PDF invoice for every entry in the bank and put them together. It is very easy to find out which invoices you didn't download yet, if an invoice still needs payment or if you were sent an unexpected invoice. Lately I have refined this further and automated some of the matchmaking too, using Apache PDFBox to read the content of the invoices.