How to import data from google sheets into a database?

Question

how to dynamically link data from google spreadsheet to a database ?

Manas Mohapatra · Answer

Please find below link that may help you to read data from google spreadsheet: https://developers.google.com/sheets/api/quickstart/dotnet http://www.hanselman.com/blog/NuGetPackagesOfTheWeek12AccessingGoogleSpreadsheetsWithGDataFromCAndHostingRazorTemplatesToGenerateHTMLFromAConsoleApp.aspx Once you are done with reading do a bulk insert into database using SqlBulkCopy class: http://www.aspsnippets.com/Articles/SqlBulkCopy-Bulk-Copy-data-from-DataTable-DataSet-to-SQL-Server-Table-using-C-and-VBNet.aspx