The Scenario
You are a database administrator. The security audit is next Monday and the compliance checklist requires a read-only reporting role on each of twenty Neon project branches used by the analytics team. The auto-generated credentials must be documented in a secure tracking workbook before the auditor arrives.
The Excel workbook already has project IDs in column A, branch IDs in column B, and role names in column C. Columns D and E are empty.
The bad version of the next four hours:
- Open the Neon dashboard
- Navigate to project one, click into the branch, find the Roles section, create the role
- Copy the auto-generated password before it disappears from the UI
- Paste the password into the workbook
- Realize you navigated away from project three without copying the password
- Go back, reset the password, document the new one
- You finish at 6 PM with two passwords that may have been reset and one that definitely was.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the role specification workbook and calls the Neon API to create each role, capturing the auto-generated credentials automatically.
Open the SheetXAI sidebar and type:
Create PostgreSQL roles in Neon for all rows in my Excel sheet — each row has a project ID, branch ID, and role name — then write the new role's auto-generated password into the 'Password' column.
SheetXAI iterates through all twenty rows, creates each role, and writes the auto-generated password back into the workbook immediately after creation.
What You Get
A complete credential tracking workbook with:
- Password column — auto-generated credentials written immediately after each role is created
- Consistent role naming — names from the role column are used exactly
- Audit-ready layout — each credential is tied to the exact project ID and branch ID in the same row
Passwords are written as soon as each role is created, before SheetXAI moves to the next row.
What If the Data Is Not Quite Ready
Role creation workbooks often arrive with naming inconsistencies. SheetXAI normalizes and creates in the same prompt.
When role names have spaces or uppercase characters
Normalize the role names in the role column to lowercase with underscores. Then create a role in Neon for each row using the project ID and branch ID columns, and write the generated password into the Password column.
When some rows already have a password from a previous run
Skip any row where the Password column already has a value. For the remaining rows, create a Neon role and write the generated password into the Password column.
When you need both a read-only and a read-write role per branch
For rows where the role name ends in '_ro', create a read-only role. For rows where it ends in '_rw', create a read-write role. Write the generated password into the Password column for all rows.
When the auditor wants a credential summary on a separate tab
Create a Neon role for each row using the project ID, branch ID, and role name columns. Write the generated password into the Password column. Then write a summary on a new tab called 'Audit Summary' listing project ID, branch ID, role name, and password for every row that was created successfully.
The pattern: the workbook is both the provisioning manifest and the credential record. One prompt creates the roles and documents the credentials.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with Neon project IDs, branch IDs, and role names, then ask it to create the roles. The Neon integration is included in every plan. See also how to add team members to Neon projects in bulk from Excel or the Neon in Excel overview.