Automated SQL Data to Google Sheets -- 3

$30-250 USD

Closed

Posted 4 months ago

$30-250 USD

Paid on delivery

I'm in need of a Google Sheet that automatically pulls data from a SQL database (specifically, [login to view URL] data from a website). The sheet should sort and categorize the data into filterable and selectable presets. Ultimately, I need a scatter plot to visualize these filters. Key Requirements: - Categorization of data by alliances/guilds, players, and their villages with map coordinates - Ability to filter and select multiple presets - Creation of a scatter plot from the data Ideal Skills: - Proficiency in Google Sheets and SQL - Experience with data sorting and categorization - Ability to create complex and interactive spreadsheets - Basic understanding of data visualization techniques [login to view URL] this needs to be automated so that sql updates from site every 24 hrs. also needs the operation sheet when posting in new/inserting new data to keep data together. (currently operation sheet is copy pasted without formulas, and when new data is inserted it messes up the organization of the data columns). setup of sheet should be as follows. -sql data paste in -background page for sorting of information. -filter page-this applies the filters to the recorded and sorted data. currently is has 4 selections/drop downs needs to be expanded to 10. -master sheet is generated from previous filter sheet - needs additional selection for each row as filter/formula so that they are included on the next page or not/should not affect this sheet. -operation sheet- this is created from the master sheet depending on the selections made -graph page should be populated off the master sheet

Database Administration

Project ID: 39236412

About the project

40 proposals

Remote project

Active 2 mos ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

40 freelancers are bidding on average $161 USD for this job

@techplusintl

This can be accomplished with the following steps: ? Step 1: Connect Google Sheets to SQL Database ✅ Use Google Apps Script or Google Sheets' JDBC connection (if database access allows). ✅ Alternatively, use Google Cloud SQL Connector for seamless integration. ✅ Automate data fetching with a scheduled trigger (e.g., every 10 minutes). ? Step 2: Sorting & Categorizing Data ✅ Use Google Sheets formulas (QUERY, FILTER, SORT) to process data. ✅ Implement dropdown menus for selectable presets (via Data Validation). ✅ Add custom scripts/macros to automate filtering and sorting. ? Step 3: Scatter Plot Visualization ✅ Use Google Sheets' built-in charting tools to generate a scatter plot. ✅ Ensure the X & Y axes dynamically update based on filtered selections. ✅ Optionally, use Google Data Studio (Looker Studio) for advanced visualizations.

$250 USD in 3 days

4.9

(153 reviews)

7.8

@akritisood94

With proficiency in Google Sheets and an in-depth understanding of SQL, I'm adept at building systems that automatically pull and manage data from a SQL database, just like the one you require. I can meticulously categorize and sort the data based on alliances/guilds, players, villages and even their coordinates for convenient filtering and selection in a google sheet. Furthermore, I'll have your sheet updated with fresh data every day to keep it up-to-date. My experience in data processing and analysis paired with my basic grasp of data visualization techniques will ensure the integration of an interactive scatter plot into your Google Sheet to give you a visual representation of filtered data. I'll set this up seamlessly to provide you with the clarity and insights you need. Operation sheets getting amiss while inserting new data can be exasperating. But fear not! My expertise in Excel VBA is perfect for troubleshooting such issues. I can develop advanced macros that will help maintain coherent organization of data columns when new data is added, eliminating human error from copy-paste operations. With me on your project, you can relax knowing your database is being managed meticulously and professionally.

$200 USD in 2 days

4.9

(477 reviews)

7.7

@Giovanni704

Hi there! As I have read, I see you need help automating SQL data transfer to Google Sheets, ensuring real-time updates and seamless integration, and I could help you! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. I know all the most used softwares to do this project specifically, I could even give you some other options in case you think is better to use other tools. Send me a message so I can show you my previous work and we can discuss more. Best regards, Giovanni.

$30 USD in 1 day

4.9

(67 reviews)

7.2

@ZohaibRoy

⭐⭐⭐⭐⭐ Create an Automated Google Sheet for SQL Data Visualization ❇️ Hi My Friend, I hope you're doing well. I've reviewed your project requirements and see you're looking for an automated Google Sheet that pulls data from a SQL database. Look no further; Zohaib is here to help you! My team has successfully completed 50+ similar projects for data management and visualization. I will set up an efficient system that updates every 24 hours, categorizes data, and creates a scatter plot to visualize your filters. ➡️ Why Me? I can easily create your automated Google Sheet as I have 5 years of experience in Google Sheets and SQL. My expertise includes data sorting, categorization, and building interactive spreadsheets. Additionally, I have a strong grip on data visualization techniques, ensuring a comprehensive solution for your project. ➡️ Let's have a quick chat to discuss your project in detail. I'll showcase samples of my previous work, demonstrating my ability to create efficient data management systems. Looking forward to chatting with you! ➡️ Skills & Experience: ✅ Google Sheets Proficiency ✅ SQL Database Management ✅ Data Sorting ✅ Data Categorization ✅ Interactive Spreadsheet Design ✅ Data Visualization ✅ Filter Implementation ✅ Automation Techniques ✅ Scatter Plot Creation ✅ Formula Integration ✅ Operational Sheet Management ✅ Problem-Solving Skills Waiting for your response! Best Regards, Zohaib

$74 USD in 2 days

4.9

(34 reviews)

6.3

@mobimubasir

Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply

$150 USD in 1 day

5.0

(64 reviews)

5.7

@ayesha0124

Hi there. I am a full stack developer with experience in Database Administration, Data Processing, MySQL, Excel and SQL. I have worked with many similar projects. I and my team of developers strive to give our best. Please contact to discuss in detail. Regards

$250 USD in 7 days

5.0

(6 reviews)

5.4

@HiraMahmood4072

Hi, I hope you're doing well. I understand you're looking for Automated SQL Data to Google Sheets I am the ideal candidate for your project. I have read the provided job description and I understand what you are looking for. ✅ No Upfront Payment ✅ Release Milestone After Completion ✅ Unlimited Revision I have over 10+ years of experience Data Processing, Excel, SQL, MySQL, Database Administration. Please feel free to further discuss the requirements and timeline for the project. I'd be happy to assist you. I am ready to start right now. You can visit my Profile https://www.freelancer.com/u/HiraMahmood4072 Thank you

$140 USD in 7 days

5.0

(31 reviews)

5.3

@ifaizabbas

Hello! I am confident that I can help you with the project based on your specific requirements. With years of experience in the relevant field, I will ensure that the work is completed efficiently, on time, and with high-quality results. I prioritize clear communication, attention to detail, and meeting client expectations. Whether it's handling specific tasks or providing solutions, I am dedicated to delivering results that perfectly fit your needs. Let’s collaborate to achieve your goals and deliver outstanding results. Looking forward to working with you!

$30 USD in 2 days

4.6

(9 reviews)

3.3

@AbdullahLasharii

I’m excited to help automate your Google Sheet to integrate with your SQL database.  Here's my plan: ➤ 1. SQL Integration: I’ll set up the sheet to pull data automatically from the SQL database and ensure it updates every 24 hours. ➤ 2. Data Categorization: I will categorize data by alliances, guilds, players, and villages, including map coordinates. The data will be sorted and organized for easy filtering. ➤ 3. Filter Expansion: The current filter system will be expanded to include 10 dropdowns, enabling you to filter and select multiple presets. ➤ 4. Master Sheet Creation: I will create a master sheet, which will be generated from the filtered data, and I’ll add selections for each row based on your required filter/formulas. ➤ 5. Operation Sheet Automation: The operation sheet will be linked to the master sheet so the data remains consistent when new entries are added, avoiding disruptions to column structure. ➤ 6. Data Visualization: I’ll create a scatter plot that visualizes the filtered data on a separate graph page. ➤ 7. Automation: I’ll automate the process to ensure the SQL data refreshes every 24 hours, and no manual intervention is needed. I look forward to building an efficient solution for you.  Risk-Free Collaboration: I offer a full refund if my work doesn’t meet your expectations—and you can keep this message as proof. Best regards, Abdullah Lashari

$100 USD in 5 days

5.0

(2 reviews)

2.2

@hamzakhattabi

Hey there, I am a Google Sheets and SQL expert with over 5 years of experience. I can automate your Google Sheet to pull SQL data every 24 hours, ensuring smooth data integration and organization. I will set up structured background sorting, enhance filtering to 10 dropdowns, and refine the master and operation sheets to maintain data integrity. Additionally, I’ll configure a scatter plot that dynamically updates based on your selections. My expertise includes SQL queries, Google Apps Script, and advanced data visualization. Let’s get this fully automated and optimized. Feel free to reach out! Regards,

$140 USD in 2 days

5.0

(1 review)

1.8

@Visharaa2024

As an experienced developer with over 8+ years of experience, and specializing in PHP, I have a high level of skill in working with MySQL and SQL databases like your map.sql. In addition, my proficiency in Google Sheets also allows me to create complex and interactive spreadsheets- which is vital for this project. Moreover, I understand the importance of data sorting and categorization for a task like yours and assure you that the resulting data will be grouped by alliances/guilds, players, and their villages with their respective coordinates. The automation aspect you've mentioned is no problem at all! In fact, I've worked on similar projects where I set up automated data updating at a specific interval. I'll make sure the spreadsheet pulls data from your SQL database every 24 hours, so you can always rely on your updated sheet. Finally, regarding visualization - my basic knowledge of data visualization techniques coupled with my ability to create scatter plots harmoniously combine practicality and aesthetics to provide you with the best result possible. My belief is to provide high-quality work before the deadline and assured client satisfaction. Looking forward to delivering the same level of performance on this project as well!

$200 USD in 7 days

5.0

(1 review)

1.2

@Jodzis

Hi, Cory I would like to grab this opportunity and will work till you get 100% satisfied with my work. I built exactly the same project as what you want to build. I have rich experience on Data Processing, Excel, SQL, MySQL, Database Administration. Let's connect in chat so that we discuss this further. Thank You

$120 USD in 7 days

0.0

(0 reviews)

0.0

@aajensia

Hello, I am a data processing and database administration specialist with experience in SQL and Google Sheets integration. I can help you automate data imports from your SQL database, organize them efficiently, and enable automatic updates every 24 hours without losing data structure or integrity. My approach includes: Setting up automatic SQL data imports to Google Sheets. Organizing and categorizing data by alliances, players, and villages with their coordinates. Creating advanced filters to customize selections, expanding current options. Developing an interactive scatter plot to visualize selected filters. Maintaining data integrity when new records are inserted. The solution will be fully automated so you can manage and visualize data without worrying about manual updates. I look forward to your response.

$100 USD in 3 days

0.0

(0 reviews)

0.0

@spositothiago

Hi, I’ve already done it many times before. Please contact me, and we can start right away. Thank you!

$250 USD in 7 days

0.0

(0 reviews)

0.0

@darshan450

Hello, I’d be thrilled to assist you in creating a fully automated and interactive Google Sheet that pulls data from your SQL database, organizes it efficiently, and visualizes it as a scatter plot. Here’s how I’ll approach your project: SQL Integration: Establish a seamless connection between your SQL database and Google Sheets using automation tools (e.g., Apps Script or third-party integrations) to refresh data every 24 hours. Data Organization: Develop a background sorting page for alliances/guilds, players, and villages Ensure a clean, structured layout that retains column integrity when inserting new data. Advanced Filtering: Expand filter capabilities from 4 to 10 drop-downs, enabling advanced customization. Create a dynamic master sheet that responds to selections and filters applied Automate the creation of an operation sheet with formulas intact, preserving data coherence. Use the master sheet to generate an interactive and filter-based scatter plot for clear insights.

$140 USD in 7 days

0.0

(0 reviews)

0.0

@prashants245

think my attention to detail and accuracy set me apart from other candidates. I also have a lot of experience working with data entry and administrative tasks. I'm confident that I have the skills and experience necessary. I'm also very motivated to get the job done, and I have a lot of enthusiasm

$140 USD in 7 days

0.0

(0 reviews)

0.0

@Vadherraj4

I have 6+ years experience in data management and reports generation with 99% Accuracy within provided timelines

$140 USD in 7 days

0.0

(0 reviews)

0.0

@julianr68

Hello, I can automate your Google Sheet to seamlessly pull data from your SQL database every 24 hours, ensuring accurate and up-to-date insights. With my expertise in SQL, Google Sheets scripting, and data visualization, I’ll structure the sheet for efficient filtering, sorting, and interactive scatter plots. I'll also ensure the operation sheet remains intact while inserting new data, preventing disruptions in organization. Would love to discuss further and tailor the setup to your exact needs. Let’s get started! ?

$100 USD in 1 day

0.0

(0 reviews)

0.0

@rajendrab71

HII, I’m excited to bid on your Google Sheet + SQL Automation project! ? With my expertise in SQL, Google Sheets automation, and data visualization, I’m confident I can create a fully automated, filterable, and interactive solution that meets your requirements. Here’s how I’ll deliver the project: SQL Integration: I’ll set up a 24-hour automated data refresh → Ensuring your SQL data is always up to date. Smart Categorization: Players, alliances, & coordinates → Sorted into filterable presets. Background page → For optimized sorting & organization. Advanced Filtering: Expand the current 4 filters to 10 → For more granular data analysis. Automated Scatter Plot: Generate a dynamic scatter plot → From the master sheet data. Keep it visually clear & easy to interpret. Seamless Operation Sheet: Ensure the operation sheet maintains formulas → Even after inserting new data → Preventing organizational issues. Why Hire Me? Proficiency in SQL + Google Sheets automation. Experience with data visualization & filterable spreadsheets. Commitment to accuracy, performance & clean organization. I’m fully aligned with your project scope & budget → Ready to deliver a highly organized, automated solution. I guarantee quality, efficiency & timely delivery. Looking forward to collaborating with you! ? Best regards, Rajendra

$140 USD in 4 days

0.0

(0 reviews)

0.0

@YaseenAli7

Hi, I'd love to help you automate your Google Sheet by integrating live SQL data updates, advanced filtering, and a dynamic scatter plot for visualization. ? Here’s How I’ll Approach Your Project: - The sheet will pull fresh data from your SQL source every 24 hours. - Data will be automatically sorted into alliances, guilds, players, and villages with map coordinates. - The current 4-selection dropdowns will be expanded to 10 customizable filters for precise data segmentation. - A structured approach will ensure that new data inserts don’t break formatting or misalign columns. - A dynamic visualization will be generated based on the filtered data. I will also ensure that the operation sheet remains intact when new data is posted, maintaining all necessary formulas and relationships between sheets. With my background in SQL, Google Apps Script, and spreadsheet automation, I can ensure a seamless and fully automated solution. Let’s discuss your specific needs further—I’m ready to start! Looking forward to your response. Best regards, Yaseen.

$190 USD in 7 days