Here is how I learned to do some scripts to (a) use the WordPress API to dynamically populate some cells in a Google Spreadsheet; and (b) how to script a way to use these results to dynamically update text and menus in Google Forms.
A very comprehensive writeup of integrating Google Forms/Sheets and WordPress with Google Apps Script.
Source: Making Google Forms and Spreadsheets a Bit Less Rigid Block Style – CogDogBlog
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.