How to trigger a script in Google Spreadsheet with .NET?

How do I use a Google Sheet to get information from a web link and copy/paste specific information in a spreadsheet?

• I know that there is a possibility to write a script, but I do not know how to do that. The idea behind this is simple. I want this script to check a database in my backoffice (which is browser based) at work, and to open specific files, copy the name of a customer, e-mail address of a customer and to put this information in a spreadsheet so that I can use Mail Merge and send them a custom e-mail.

• Answer:

  How is that database accessible?  Google Spreadsheets exist in the cloud, and only has access to data that is readily available over the internet. Even though you are using it on a local computer on a local network, it actually has no access to the resources directly. In other words, your database needs to be accessibly outside your internal system.  There is a StackOverflow thread that sort of addresses this here:  http://stackoverflow.com/questions/14924227/google-app-script-and-local-database-connectivity If the database isn't accessible, you will need to do this through some sort of migration process where the DB provides a regular extract to a local drive, and you write an app script that imports the data for use in your spreadsheet.