Find Jobs
Hire Freelancers

Retrieve SQL Server Product Data and Fill Columns in Google Sheet

$30-250 USD

Terminado
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
We have a Google Sheet that we use for customer management and shipping. We have a SQL Server product database. We want to query the database and retrieve product data based on the item number input by the Google Sheet user and put product data into certain columns. We have the SQL query written that retrieves the proper details, but we need to code the Google Sheet to retrieve that data based on user's item number input. Security is important, so we want to make sure the connection is secure and that the product data is only accessible by Google Sheets and that data, including SQL connection details, is not compromised during transmission
ID del proyecto: 18115388

Información sobre el proyecto

19 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi, I would like to propose a solution. I can create a PHP script for you that you can put on your web server whose sole purpose would be retrieve product data from SQL server using the SQL query you've developed and then deliver it to the client asking for that data using the item number. Here the client can be Google Sheets. I can then write a Google Apps Script for your Google Sheets that will fetch that data from the PHP script by providing it the item number which the user has input on the sheet. About me ======== I'm a Software Developer. I have skills and experience in modern web technologies including HTML5, CSS3, JavaScript, PHP, and MySQL as well as in building Google Apps Script for Google Sheets. If you would like to discuss your project with me then feel free to contact me by sending me a message even when I'm offline. I typically reply within a few minutes when online and within a few hours when offline.
$150 USD en 5 días
5,0 (7 comentarios)
3,0
3,0
19 freelancers están ofertando un promedio de $151 USD por este trabajo
Avatar del usuario
i am a lead .NET software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck
$150 USD en 1 día
4,9 (168 comentarios)
7,8
7,8
Avatar del usuario
SQL Data can be moved from/to google spreadsheets . 1- Connect SQL server to Google sheet via JDBC (Have to write code) 2-After successful connection product information will be fetched from sql query based upon Product number field from Google sheet. 3-Connection will be secure as we will be using connection information in the code behind google sheet. Looking forward to have a chat with you to discuss in details.
$200 USD en 5 días
5,0 (241 comentarios)
7,6
7,6
Avatar del usuario
So You want to sync data between sql and google sheet. Below is my solution for your requirement. We will develop a simple desktop or web app which will contains a text box (input for item number) and button. when the user press the button it will take all the data for that item number and update the google sheet. About me: Hey, My name is Tahir; I'm a Microsoft Certified Solutions Developer(MCSD) located in Islamabad. I've a sound experience in asp.net(core), mvc, entity framework, sql server, web api and bootstrap. I'm highly interested in your work, and i believe it fits my area of expertise. I'm looking forward to hear from you.
$133 USD en 3 días
5,0 (37 comentarios)
6,0
6,0
Avatar del usuario
Hi There I've excellent programming and development skills and knowledge. I can provide an efficient, perfect, well documented development of your Programming and Computer project according to 100% accuracy and requirements, with dedicated support. Thanks Farah Saif
$155 USD en 5 días
4,9 (84 comentarios)
5,8
5,8
Avatar del usuario
Hello? How are you? I have good experiences in "Retrieve SQL Server Product Data and Fill Columns in Google Sheet" as you can see my profile for these (.NET, Microsoft SQL Server, SQL). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.
$155 USD en 3 días
4,7 (18 comentarios)
5,1
5,1
Avatar del usuario
Hello my name is Fares, I can get it done perfectly the bot as you want let's chat when you are online, Thanks
$100 USD en 3 días
4,7 (17 comentarios)
4,4
4,4
Avatar del usuario
Hi, I am interested in your project for sql server => google sheets t please contact me for further discussion best regards
$200 USD en 3 días
5,0 (1 comentario)
3,1
3,1
Avatar del usuario
Hello, Interested in the job. I am a Software Engineer specializing in end-to-end Web Development with expertise building solutions that utilize Google's GSuite platform (which includes Google Sheets). Using Google Apps Script (GSuite's native server-side scripting language) I can query your SQL server database using a JDBC connector and populate your Google Sheet. Security should not be an issue since the GAS scripts are executed from Google's servers. Thank you for taking the time to review my proposal and I look forward to discussing your project in greater detail if afforded the opportunity. Regards, Damion Murray DimuDesigns
$250 USD en 5 días
5,0 (1 comentario)
0,8
0,8
Avatar del usuario
had experience with .Net and SQL will finish the project before dead line and will negotiable on the price
$111 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
$200 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I'm working every day with SQL server database and i'm very excited about my work. I have been working for almost 3 years in a datawarehouse department. I don't consider myself an expert, but I am an ambitious young man who can accomplish this project. Best regards, Andrei
$45 USD en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design. Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired. 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle (PL/SQL) 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
well experienced in integrating the .net application with excel/google sheet using ODBC/ADO/JADE connection. Generated custom management dashboard report for a manufacturing industry.
$111 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Microsoft certified SQL professional. Worked with 5TB database. Excel in DB and ETL desings along with performance tuning. Written complex queries and procedures. Experience in loading data into google sheets periodically using SSIS tool. Can provide more details in chat
$200 USD en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Newberry, United States
5,0
14
Forma de pago verificada
Miembro desde ago 26, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.