Real-Time SQL-Google Sheets JS Script

$30-250 USD

Zrušeno

Zveřejněno

před 3 měsíci

$30-250 USD

Zaplaceno při doručení

I need an adept JavaScript coder capable of handling SQL server and Google Sheets tasks. You'll be developing a script that performs the following functionalities: Task Descriptions: - Populate Google Sheets with data fetched directly from a SQL server. - Retrieve data from Google Sheets and update the SQL server respectively. - Execute these tasks in real-time. Ideal Candidate: - Proficient in JavaScript - Familiar with Google Sheets and SQL Server integration - Has experience interfacing databases directly - Knowledgeable in real-time data processing setups. Your understanding of real-time data manipulation and strong JavaScript and SQL skills will equip you to undertake this task well. A good understanding of Google Sheets is also needed. Problem: We are using a google sheet to hold some data (fields will be provided later). It has reached a limit for linked sheets....The source spreadsheet has reached the maximum capacity for sharing and importing. Solution Requirements: create a google webapp that will query a sql server db based on a value that can be matched in the sql server and return the record to a specified google sheet and then if it doesn't exist then check the db and add the record to the source sheet and have the destination sheet check again for the value. For example, there are two google sheets one called properties and another called detail analysis. Detail analysis has some fields that are linked to the properties google sheet to get data from it to a cell in the detail analysis sheet. if the property that it is looking for is not found in the properties sheet then it should check the db.

JavaScript

Software Architecture

Microsoft SQL Server

SQL

Google Apps Scripts

IČ projektu: 37757439

O projektu

36 nabídky

Vzdálený projekt

Aktivní před 2 měsíci

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@OyatechJPCoLtd

Hi! As a seasoned JavaScript coder, I'm confident that I can develop a script that will meet your requirements and solve your problem. I've worked extensively with SQL servers and Google Sheets, so I know how to integrate them seamlessly. To address your issue with the limited sharing and importing capacity of your Google Sheets, I'll create a Google Web App that will act as a bridge between your SQL server and Google Sheets. This web app will be able to query your SQL server based on a specified value and return the corresponding record to your Google Sheet. If the record doesn't exist in the sheet, the web app will check the database and add the record to the source sheet. Then, it will check the destination sheet again for the value. Here's a high-level overview of how I'll approach this: Create a Google Web App that can interact with both your SQL server and Google Sheets. Write a script that queries the SQL server based on a specified value and returns the corresponding record to your Google Sheet. Implement real-time data processing to ensure that the Google Sheets are updated as soon as changes are made to the SQL server. Test the script thoroughly to ensure that it's working as intended and that there are no errors or bugs. I'm confident that my skills and expertise make me the ideal candidate for this job. I'm looking forward to the opportunity to work with you and deliver a high-quality solution that meets your needs. Let's chat more about how we can get started!

$100 USD v 3 dnech

0,0

(1 recenze)

0,0

36 freelanceři nabízejí v průměru $160 USD za tuto práci

@MashoodurRehman1

I am a proficient JavaScript developer with expertise in Google Sheets and SQL Server integration. I have experience interfacing databases directly and implementing real-time data processing setups. With my strong JavaScript and SQL skills, I can develop a script to populate Google Sheets with data from a SQL server, retrieve data from Google Sheets, and update the SQL server in real-time. I understand the problem of reaching the limit for linked sheets and am capable of creating a Google web app to address this issue.

$250 USD v 2 dnech

4,9

(128 recenze)

7,5

@usamae

I'm an experienced JavaScript coder with expertise in SQL server and Google Sheets integration. I can develop a real-time script that populates Google Sheets with data from a SQL server and updates the server with data from the Sheets. I have a strong understanding of real-time data manipulation and have worked with databases directly. Can you provide more details about the specific fields and values that need to be matched in the SQL server?

$250 USD v 7 dnech

4,9

(58 recenze)

6,2

@Jennycreation

Hello sir i am full time freelancer and have 15+ years of experience in - Software and Web development in asp.net c#, javascript,sql server . - Database : Microsoft SQL Server - Front End Technology : HTML 5, JQUERY, AJAX, Javscript, Bootstrap - Third party API integration Like Payment Gateway , SMS and Email API integration, and banking Financial API , Insurance API - Automation Bot Software Work. Work on many Automation bot software and website scraping work. Let me know i can help on your project. Thanks

$250 USD v 7 dnech

5,0

(11 recenze)

5,9

@stelianrosca618

With over a decade of experience in web development and deep proficiency in JavaScript and SQL, I am confident that I can handle the tasks outlined in your project description. My career as a full-stack expert has equipped me with the ability to interface databases directly and process real-time data effectively - both skills that will be vital for this project. Moreover, my experience includes working with data-heavy systems like Laboratory Information Management Systems (LIMS) which are similar in complexity to your project. Having built numerous websites, I am well-versed in leveraging technologies and platforms such as Google Sheets API and SQL Server to deliver seamless data integration. Not only can I fix the problem with the current linked sheets limitation, but I can also create a Google WebApp (`specific to property-detail analysis relation within your case of course`) that will effectively query the SQL server based on specified values and handle any necessary data imports or exports without exceeding any capacity limits. Throughout my career, my approach has always been to provide high-quality work while maintaining effective communication - qualities that have consistently satisfied my clients. With me on board, you can be assured of both a technically sound solution and constant updates on the project's progress. Let's connect soon so I can learn more about your specific needs!

$250 USD v 7 dnech

5,0

(15 recenze)

6,0

@akritisood94

With my diverse expertise across JavaScript, SQL, and Software Architecture, I'm primed to develop the real-time SQL-Google Sheets JS script your project needs. I have an excellent grasp of JavaScript, ensuring a seamless integration between Google Sheets and SQL server tasks. My past experience working with databases directly will prove invaluable in fetching data from your SQL server and updating Google Sheets accordingly, allowing you to bypass the limitations you're currently facing. Not only will I reduce your dependence on links and imports, but I'll also create a Google WebApp that intelligently queries your SQL Server DB based on provided values. Whether it's fetching specific records or adding new ones if they don't exist in the source sheet, my solution will give you the flexibility you need for this project. My commitment to client satisfaction means that I’ll be focusing my problem-solving skills on delivering exactly what you need while meeting deadlines and respecting budgets. To top it off, my innovative and creative approach to challenges ensures we’ll not only solve your current limitation but find better ways for managing data in Google Sheets going forward. Join me on this journey, and we’ll transform this project into something truly remarkable!

$200 USD v 2 dnech

4,7

(44 recenze)

5,9

@ZohaibRoy

✅ JavaScript Developer - Real-time Data Integration Expert! ⭐⭐⭐⭐⭐ Hi My Friend, Hope you are doing well. I've checked your project requirements and noticed you're looking for a skilled JavaScript developer. Look no further; Zohaib is here to assist you! Our team has extensive experience in JavaScript, SQL server, and Google Sheets integration, ensuring seamless real-time data handling. ➡️ Why Me? I bring expertise in JavaScript coding, SQL server management, and Google Sheets integration. With our proficiency, we ensure efficient real-time data processing and synchronization. ➡️ Let's have a quick chat to discuss your project details. I'll explain our approach and showcase samples of our previous work, demonstrating our capabilities in handling similar tasks. Looking forward to discussing this with you in our chat. ➡️ Skills & Experience: ✅ JavaScript Development ✅ SQL Server Management ✅ Google Sheets Integration ✅ Real-time Data Processing ✅ Database Interfacing ✅ Script Development ✅ Data Synchronization ✅ Web Application Development ✅ Problem-solving Skills ✅ Communication Skills Waiting for your response! Best Regards, Zohaib

$220 USD v 3 dnech

5,0

(27 recenze)

5,7

@kemaltulum

Using JDBC, we can connect to external databases on Apps Script. We can use that and run sql queries to update data. On the other hand, to make it real-time and efficient, we should optimize the data read and write operations to db. I would like to examine your system and come up with a powerful solution.

$200 USD v 7 dnech

5,0

(11 recenze)

5,1

@maksabakanovich

Hello. thanks for posting. I have just read your description and understood what you want. I am familiar with JavaScript and Google Sheet, Database SQL. I am sure I can do it perfectly. Please contact me. Thanks, Maksim

$140 USD v 7 dnech

5,0

(9 recenze)

4,8

@muktisaini01

With my 7-year journey as a Full Stack Developer, front and center are the skills and experiences that make me a perfect fit for your real-time SQL-Google Sheets JavaScript Script project. I have numerous instances of code in JavaScript that have interfaced directly with databases. On top of that, my experience with Google Sheets is profound, and I'm confident that it will scale in well to retrieve and update data from both Sheets and SQL servers. What sets me apart is my strength in real-time data processing - a key requirement for this project. Additionally, I am up-to-date with the knowledge base that surrounds Google's advancements and can comfortably create a google web app that queries SQL server db to handle the maximum capacity on your source sheet. As an added bonus, I've handled hybrid apps for iOS & Android using React Native & Flutter - technologies pursue mobile/app components where great database management is involved - just like this project. If given the chance to work with you, not only will I complete this particular task promptly, but I will also provide you with efficient solutions to future database issues that may arise. Thank you for considering me Tarika Saini to do justice to your project. Let's get started!

$140 USD v 7 dnech

5,0

(2 recenze)

4,3

@souyah

Hi, there! Having confirmed the job posting, it seems like you might be looking for a senior developer for your project - Real-Time SQL-Google Sheets JS Script. I have worked with similar projects so that I can provide you with a satisfied result. This project really caught my attention because I have been working in this specific industry for 10 years now, and have not only gained experience or knowledge but, I have got the answer to the main problem which many clients face which is communication and I can assure that you will be satisfied and updated throughout the process, if we move forward. Can't wait to have you on chat with me, and to get started with this project. Regards

$200 USD v 3 dnech

5,0

(5 recenze)

3,9

@idogoldblatt

As an experienced and proficient software developer, I am confident that I possess the necessary skills to tackle your SQL-Google Sheets scripting requirements. With a solid foundation in JavaScript and SQL, handling real-time data manipulation comes second nature to me. Additionally, my familiarity with Google Sheets and aptitude to interface databases directly makes me the ideal candidate for this project. I will leverage my four years of solid experience in software development, specifically in API creation and third-party services integration in Python and Node.js to create a dynamic Google web app that efficiently queries your SQL server DB. This app will seamlessly query your database based on values provided to it, returning matching records in real-time while also ensuring data integrity. You'll have the advantage of working with a seasoned professional who combines creativity, efficiency, and passion to deliver high-quality solutions on time. My commitment doesn't end with completion; I provide post-development support and maintenance for true long-term success. Let's get started on this project and surpass your expectations together.

$170 USD v 7 dnech

5,0

(2 recenze)

4,1

@dillonmarszal

Hello. I am a SR. WEB DEVELOPER who can certainly make your idea into real! I have enough experience in Software Architecture, Microsoft SQL Server, Google Apps Scripts, SQL and JavaScript. I am waiting your reply here, please don't hesitate contact me anytime. Thanks.

$200 USD v 7 dnech

5,0

(4 recenze)

3,8

@Nehag510

Hello With diverse expertise in Google Apps Scripts, JavaScript programming, SQL databases, and Google Sheets integration, I am ideally suited to deliver exceptional solutions for your project. Having come across similar challenges in my previous projects, I understand the limitations that can arise with large datasets in Google Sheets and the need to integrate SQL databases effectively. To overcome these obstacles, I propose developing a comprehensive Google Web App using real-time data processing that will not only query and retrieve data from your existing SQL server but also update it as needed to keep your Google Sheets up-to-date. My experience working with various databases like MySQL and MS SQL Server will ensure efficient and accurate handling of your dataset. Moreover, I believe my Full stack developer skills are a bonus for tackling complex projects like yours. From designing the database architecture to implementing secure API integrations, I'll handle it all. Thriving on challenges and delivering excellence gives me an edge in this field. Let's discuss how we can optimize your process and overcome the sharing capacity constraints of your sheets through my tailored solution. I look forward to working with you. I am waiting for your positive response!!! Thank you

$250 USD v 7 dnech

4,8

(5 recenze)

3,8

@IMBASANTAKUMAR

As an experienced coder with a strong background in JavaScript, Google Apps Scripts, and SQL, I believe I'm a perfect fit for your project. My 12+ years in prominent tech companies such as IBM and Amazon have equipped me with the skills necessary to handle real-time data manipulation and integration tasks effectively. Additionally, I'm well-versed in working with Google Sheets, having developed several efficient scripts and web apps for data management purposes. My proficiency in JavaScript allows me to build robust, reliable and efficient scripts to ensure seamless communication between your SQL server and Google Sheets. Furthermore, my understanding of databases combined with my meticulous approach to coding will help optimize performance to avoid hitting shared/import limits on Google Sheets. Lastly, my core skill set extends to all expectations outlined in your project description including fetching and updating data from Google Sheets, as well as integrating and interacting with SQL servers. By selecting me for this task, you can be confident that you're leveraging ample experience along with a steadfast commitment to quality work delivery.

$40 USD v 1 dni

5,0

(12 recenze)

3,3

@Nilufer2024

Hi, Aharon N.! I have worked with similar projects so that I can provide you with a satisfied result. Having confirmed the job posting "Real-Time SQL-Google Sheets JS Script", I truly feel that you're looking for ambitious, creative and nice people who enjoy Google Apps Scripts, SQL, JavaScript, Microsoft SQL Server and Software Architecture. I am fully available to get started on your project immediately and you will find it interesting to discuss the project details. Regards Nina

$130 USD v 2 dnech

5,0

(1 recenze)

3,2

@angelgrod

Hello, I've checked your project description right now. I really excite for your project purpose. Because I feel very confidence in your project and I can finish project asap in according to your requirements. Please contact me for more discussion. Thanks for job posting.

$200 USD v 3 dnech

4,4

(2 recenze)

2,9

@ClamsCasino

Hello, After reviewing the job description, I am confident that I can deliver you great result because I have rich experience in this role. However, I do have a few questions that I would like to discuss further. I am eager for the opportunity to collaborate with you and am looking forward to discussing how I can contribute to your project. Thank you for considering my proposal. Best regards, Nathan

$90 USD v 2 dnech

4,5

(6 recenze)

2,6

@InvokeByte

I am proficient in Google App script and I will integrate the SQL server to handle all the queries as per your needs. I am excited to work on this project. Connect with me to discuss this more in detail. Thank you.

$200 USD v 7 dnech

5,0

(4 recenze)

2,5

@zorandev

Hello, Aharon N. Your post for the "Real-Time SQL-Google Sheets JS Script" stood out to me because it is extremely similar to the work I’ve provided for many of my other clients. I am especially skilled in technologies such as Microsoft SQL Server, Google Apps Scripts, JavaScript, Software Architecture and SQL and many other technologies and frameworks. By the way, I am very interested in long-term cooperation and I am ready to work full-time. I can start work as soon as possible. I would be happy to discuss your project needs and how I can help you meet them. I look forward to talking to you! Regards, Zoran

$140 USD v 4 dnech

0,0

(0 recenze)

0,0

@chornyiartur0451

❤️❤️ Hello Aharon N. ❤️❤️ Thank you for considering my bid. After carefully reviewing your project description, I am confident that I can complete your project-Real-Time SQL-Google Sheets JS Script within the given time frame. I have expertise in Google Apps Scripts, SQL, JavaScript, Software Architecture and Microsoft SQL Server and have completed similar projects in the past. I would be happy to share my previous work with you over chat. Please let me know if you would like to discuss further details and collaborate with me on this project. Thank you for your time. Best regards, Artur

$150 USD v 3 dnech