Process Automation

I need a script that will automatically read transactions from a google spreadsheet and then enter them into a Simply Accounting window (one at a time) and post each transaction.