Automated SQL Data to Google Sheets -- 2
Budget: $250 – $750 USD
I'm in need of a Google Sheet that automatically pulls data from a SQL database (specifically, map.sql 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
https://docs.google.com/spreadsheets/d/1p0NSeb1ahy72_U8ucWWSCS5WhAD1o6iDX-Q4tMIS19I/edit?gid=177663927#gid=177663927
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
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
https://docs.google.com/spreadsheets/d/1p0NSeb1ahy72_U8ucWWSCS5WhAD1o6iDX-Q4tMIS19I/edit?gid=177663927#gid=177663927
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