Dynamically export members to Google Sheets

When we acquire a new member, they will need to complete a longer form than the e-commerce 'sign up' form for memberships offered by SS.

If we build a custom form in SS to collect all the information we need about a user, can it automatically add each person to our Google Sheets? We need this step because our core product integrates with a document creation tool via Google Sheets, and the user's name and professional credentials need to appear at the end of the document. The name and credentials would be variable fields in our document templates.