Step 1: Duplicate The Google Sheet Template To Your Account
Open the link below and copy the template to your Google Drive account.
https://docs.google.com/spreadsheets/d/1AfOiWO8kxVA5e4irX-os1mjto_3r9dsKS-mFGNjFdy4/copy
Tip: Create a folder named AskRally
(or AskRally | {Client} | {Project}
) before copying. The setup script will generate two result folders in the same directory.
Step 2: Click Setup Rally And Complete Authetication
In your copied Sheet, wait a few seconds for the Setup Rally menu to appear. Click Setup Rally → Install Trigger to authorize the conntected appscript.
Step 3: Request AskRally API Access & Generate Key
Email us to request API access, then generate a key with full access rights. We grant every paying customer access to the API. Your keys will inherit the usage limmits of your paid plan. e.g. $20/m = 200 API chats per day. If you need to expand the limits, get in touch.
Step 4: Add Your Key And Test Run With An Audience
Paste your API key into D2.
Copy an Audience ID from app.askrally.com into column E. Choose your Provider and Mode (e.g. OpenAI / fast).
In column G, type your question. For open‑ended: set I (voting_mode) to FALSE
. For polls: set I to TRUE
and list choices in H (e.g. a) Yes, b) No, c) Maybe
).
Tip: Phrase questions as if you were asking one person. To learn more, read How to prompt in Rally to or ask our custom GPT.
Step 5: Click Simulate ☑️
Tick the simulate box in column D. Watch for Running Simulation in column M. After ~30–60 seconds, your result links will appear in columns M&N (JSON & CSV).
Testing With Images
The current template (v1.11) only supports images hosted in the template owner’s Google Drive, shared “anyone with link."
Paste the share‑link into column L.
TIP: Check the CSV responses or the AskRally UI to confirm that personas loaded your image correctly.
Adding Memories
To give all AI personas the same memory, enter text in column K.
For customized or dynamic memories per persona, get in touch.
Same Session Surveys
To carry context between questions, paste the Session ID (from the URL of your previous run) into the next question’s row before simulating.