Using a Google Sheet with Google Visualizations is relatively easy. The documentation you need is at https://developers.google.com/chart/interactive/docs/spreadsheets#creating-a-chart-from-a-separate-spreadsheet all the other options in the documentation will work, just where the data comes from is a bit different than the other examples.
Getting it work in WordPress is a bit more complicated. There are WordPress plugins available, some of which will take the data from your Google Sheet - https://wordpress.org/plugins/tags/google-charts/ you can also add your own JavaScript to your pages. There are several guides around including the one at https://premium.wpmudev.org/blog/learn-how-to-add-custom-javascript-to-wordpress-the-right-way/ -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/4c2f6537-2261-4dac-b3cb-b4f0afeb12de%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
