AskRally Google Sheet Template: Setup Guide

AskRally Google Sheet Template: Setup Guide

The AskRally Google Sheet Template lets you survey virtual AI audiences with open‑ended questions, polls, and image tests—all from a single Sheet.

July 16, 2025
← Back to Articles
Summarize in
OR

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.




Stay Updated

Subscribe to our newsletter to get notified about new articles and updates.

Rhys Fisher
Rhys Fisher

Rhys Fisher is the COO & Co-Founder of Rally. He previously co-founded a boutique analytics agency called Unvanity, crossed the Pyrenees coast-to-coast via paraglider, and now watches virtual crowds respond to memes. Follow him on Twitter @virtual_rf

← Back to Articles