Hi, the short answer yes it can be done. I did this a few years ago with the objective to see if I could get users to vote on a prototype, with the vote collecting the users name, selection and comments and then post this to Google Sheets. It is still working today so I can confirm this works for Axure v8 as well as v7.
So the process (and I am not a coder so forgive me if there are better/simpler ways).
Step 1: Create a Google Form
This is the most important step as the only way to populate into the Google Sheet is via a Google Form (from my understanding).
Add whatever data types you need in the form for your collection and you will have the option to save the form results to a Google Sheet. This will create the link between the Google Form and the Sheet.
Step 2: Publish or select the View Live Form option, right click on the resulting page and view the source code
Now you want to publish the form and look at the source code. Key information you need to collect from the source code (and copy and paste it somewhere) is:
Do this for all of the fields you want to collect.
Step 3: Axure prototype
Ok that is the most complicated piece. The next steps are quite simple.
- Create your prototype with appropriate data collention elements (ie text fields, comment boxes, dropdown selectors, radio buttons, etc)
When you are ready to pass data into Google Sheets, you need to have a submit button (or similar UI trigger for the user to click on).
For my example lets just assume it is a submit button at the bottom of the page that collects the data within your axure prototype.
Add an OnClick event to the button and
Select Open Link and select the link to an external URL or file
Now this is where it gets slightly tricky again
Flick the fx button the the right of the Hyperlink textfield - this will open up the condition builder
Assign local Variables (ie LVAR1, LVAR2) to each of the pieces of data you want to pass to the Google sheet. In my prototype i set the users name to LVAR1, their selection to LVAR2, etc). You should have a list of local variables you can now play with in your condition builder at the top of the popup window.
Find the URL for your sheet and copy it into the expression builder (eg https://docs.google.com/forms/d/e/1FAIallaii28s8sdj29duj28j2j2hui3-23-2EMm_tP-IOjlAFQ/formResponse)
Now all you have to do is start appending the parameters to the end of the URL, listing the form entry ID number against the corresponding VAR field with a &submit=Submit (as this will force the Google Form to post to the linked Google Sheet
FOR EXAMPLE your version should look similar to mine below:
Now all you have to do is test your Axure prototype. Open the prototype, add data into the fields you want to pass, click submit (and it should show you the Google Form completion success message). Check your Google Sheet and you should see the data in there.
It definitely still works for me so let me know if you get stuck and I'll try to help.