How to Configure a Google Sheets Trigger in RTILA X

[Alexandre-Kamel]

@Issac Hello, I find how to do it.

How to Configure a Google Sheets Trigger in RTILA X

Overview

This tutorial covers connecting Google Sheets as an output destination in an RTILA X automation project. Unlike the Apps Script method, RTILA X connects directly to the Google Sheets API using a Service Account, which is more robust for automated workflows.

---

Part 1 — Google Cloud Setup

Step 1: Create a Google Cloud Project

1. Go to console.cloud.google.com
2. Click Select a project → New Project
3. Name it (e.g., my-automation-project) → Create

Step 2: Enable the Google Sheets API

1. Navigate to APIs & Services → Library
2. Search for “Google Sheets API” → click Enable

Step 3: Create a Service Account

1. Go to APIs & Services → Credentials
2. Click Create Credentials → Service Account
3. Enter a name (e.g., rtila-sheets-bot)
4. Click Create and Continue → Done (skip optional role assignment)

Step 4: Generate the JSON Key

1. Click on your newly created service account
2. Go to the Keys tab
3. Click Add Key → Create new key → select JSON → Create
4. A .json file downloads automatically — store it securely

Step 5: Share Your Google Sheet

1. Open the downloaded JSON file, copy the client_email field
   (looks like: your-bot@your-project.iam.gserviceaccount.com)
2. Open your target Google Sheet → click Share
3. Paste the client_email, set permission to Editor
4. Uncheck “Notify people” → Share

---

Part 2 — RTILA X Node Configuration

In your RTILA X project, add a Google Sheets trigger/node and fill in these parameters:

Parameter	Value	Notes
Gcp Credentials Json	(paste entire content of your .json key file)	This is a secret — never share it publicly
Spreadsheet Id	YOUR_SPREADSHEET_ID	Found in the sheet’s URL between /d/ and /edit
Spreadsheet Title	my-project-v1.0	Optional — used if you want RTILA to create/find a sheet by name instead of ID
Parent Folder Id / Name	(optional)	Only needed if organizing sheets inside a specific Drive folder
Share With Email	your-email@gmail.com	Optional — auto-shares newly created sheets with you
Worksheet Name	my_dataset_sheet	The specific tab name inside the spreadsheet
Operation	append	Options: append, update, read
Cell	(leave empty for append)	Only used for update/read operations
Data	["{field1}", "{field2}", "{field3}"]	Maps your dataset’s fields to spreadsheet columns, in order
Output Variable Name	google_sheets_output	Used to reference this step’s result later in the workflow

Important Tips

• The column order in your Data array should match the header row you manually add to your sheet beforehand (best practice: create the header row first, before running the automation).
• If your automation has multiple datasets to export, you need one Google Sheets node per dataset, each pointing to a different Worksheet Name (tab), but the same Spreadsheet Id.

[Alexandre-Kamel]

@CommunityManager

I managed to import my dataset into Google Sheets using the trigger. However, the imported information is not visible when they are variables. The imported dataset is different from what I have in the scrapped data tab in rtilax.

[Issac]

That was really helpful. I appreciate you walking us through this. Feel much more confident now.

[CommunityManager]

Thank you very much Alexandre-Kamel for your help and excellent support. I have moved your reply to a dedicated thread to help other users. Thanks again it’s much appreciated!

[Alexandre-Kamel]

Thank you very much! I’m happy to help the community. RTILA X is an excellent software that I’ve learned to use and truly deserves support. It works extremely well. I recently completed a major project I wanted to automate, which I plan to share with the community in a few months once I finish fixing some minor bugs. In short, this automation enables me to enter all the active and interesting contests in my region on Instagram. I use several advanced commands, and the RTILA X agent has been a huge help throughout.