Power your WordPress loopers with live Google Sheets data 🎉

This video takes a deep dive into turning your Google Sheets into an API that provides JSON to your WordPress site and leveraging that external data to power your loopers.
Tools being used:
✅ Google Sheets
✅ WordPress
✅ Cornerstone Builder
✅ CS Charts
🔗 Medium article referenced: / turn-a-google-sheet-in...
🔗 Custom CS Looper hook: buildingonwp.c...

[@staceymarler7746]

Great stuff!

[@buildingonwordpress]

Glad you enjoyed it! Always appreciate the thumbs up and subscribe :D

[@DefinityWeb]

This is awesome! I've been asking ThemeCo for this feature for years. How does the workflow change with the drop of v6.4 today?

[@buildingonwordpress]

Thanks @DefinityWeb! Pretty nifty. The best part is (as you mentioned) that this is now a native feature within CS (versions 6.4+) via the new External API Loopers. Now all of the custom looper function.php jazz from my video can be tossed out the window. Simply:
1. Create your spreadsheet API and grab the URL (3:17)
2. Add that url as your API endpoint in the External API Looper Provider.
And you're done.

[@DefinityWeb]

🤯@@buildingonwordpress

[@DefinityWeb]

I'm so excited to add this feature to a client site. Thanks for the help and all the vids

[@larrybradshaw992]

Can you add any additional parameters to filter out certain rows of data?

[@buildingonwordpress]

Likely but you'd be getting into some more complexity for sure.

[@schulleroscar2037]

Hello, is it possible that when the data is changed on the google sheet, the change is deployed on wordpress without refresh the page?

[@larrybradshaw992]

Also is there a way to sort them, for example make them random?

[@buildingonwordpress]

Not entirely sure but you should be able to control that via the External API and a Orderby set to RAND.

[@mohamedelfellah5313]

can i use it to edit product data from google sheets

[@buildingonwordpress]

Interesting use case. There'd likely need to be another deeper integration with WooCommece at that point. This is powering the loopers themselves. You can update product data via a CSV using a tool like WPALLIMPORT

[@learnwithnorwebs]

Can this be done using Elementor?

[@buildingonwordpress]

I would imagine so. The api side of the google sheet is pretty standard so as long as you can setup consumers mapped to specific cells, you should be in good shape.