Pip Posted January 23, 2021 Share Posted January 23, 2021 Hi everyone, Is there a way to funnel data from a Google Sheet to a Processwire page? Thanks. Link to comment Share on other sites More sharing options...
BillH Posted January 23, 2021 Share Posted January 23, 2021 Yes, it can be done using the Google Sheets API (https://developers.google.com/sheets/api). I recommend the PHP Quickstart guide at https://developers.google.com/sheets/api/quickstart/php. However, be aware of the usage limits described at https://developers.google.com/sheets/api/limits. These, combined with possible performance limitations, mean that it would probably be best to get the data into PW pages – and not to display the data directly on web pages using API calls from the template file. There are various ways you could pull the data into PW pages. One would be to run a Google API call each time the page is saved (for example, hooking on saveReady). Another would be using cron (or the PW module Lazy Cron) for regular updates. 1 Link to comment Share on other sites More sharing options...
elabx Posted January 23, 2021 Share Posted January 23, 2021 I've done this another way around by sending requests from Google Sheets to a URL with custom functions. https://developers.google.com/apps-script/guides/sheets/functions 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now