connect the google sheet to the user registration form of a wordpress site.

54 views
Skip to first unread message

Mario Rossi

unread,
Aug 20, 2021, 7:44:25 PM8/20/21
to Google Apps Script Community
Hello everybody.

I am creating a website with wordpress for the first time.
I used a plugin that allows you to add fields to the user registration form beyond the basic ones.

I tried to find a plugin that allows you to extract from the database, all users with base fields and those added.

There isn't a plugin that does this because they explained to me that the extra fields data are placed in a specific table.

I ask you if with a google script it is possible to create an updated link between a google sheet and the registration form of the website, to overcome the existing problem.

Thanks

Alan Wells

unread,
Aug 20, 2021, 8:03:49 PM8/20/21
to Google Apps Script Community
If you can find a way to get your website to make an HTTPS Request, then Apps Script code can be triggered to run from the request.  I don't know anything about wordpress, so I can't help you there.  Apps Script has a couple of reserved function names, doGet() and doPost() that get triggered to run from a GET or POST request made to the published URL of the Apps Script project.  So, if your website can make a GET or POST request, then it can trigger Apps Script code to run, and obviously the Apps Script code can read your Google Sheet.  I don't know whether you'd get a cross origin policy error, or what you could do about it.

Mario Rossi

unread,
Aug 27, 2021, 6:13:52 PM8/27/21
to google-apps-sc...@googlegroups.com
Hello. It seems that my answer has not reached you. I am not an expert in programming and I don't know if it is possible to make requests or not. I entered the mysql database and saw several tables each associated with a plugin. The data can be extrapolated in different formats. If you like, I could send you the access data of the database in order to carry out a direct verification. Would you?

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/84b9282b-e013-4a36-bd69-625671f1a504n%40googlegroups.com.

Alan Wells

unread,
Aug 27, 2021, 6:28:50 PM8/27/21
to Google Apps Script Community
Sorry.  I basically try to limit my involvement to advice or a quick fix if I happen to have direct knowledge.  Maybe someone else will see the post and know what to do.
Reply all
Reply to author
Forward
0 new messages