Skip to main content

Sheet AI Actions

Use AI prompts on sheet text columns

Use AI actions in a sheet to generate content in your sheets with Fieldguide AI. AI actions generate text inside columns based on a prompt and other data from that row. You can choose a default action like Suggest a Test, or you can write a custom prompt that includes data from your Fieldguide sheet.

Once an AI action has been added to a column, users will see a button on the column’s cells where they can click to generate text, review and make changes, and insert the text into the cell.

How it works

  1. Select a column to add an AI action to.

  2. Write a prompt for Fieldguide AI.

  3. Click the AI action button on a cell to generate the result.
    ​

Create an AI action

You can create an AI action on any column whose type is set to Text. You can check a column's type in the Edit column menu.

  1. Click the vertical ellipses in the column header and select Add AI Action.

  2. Fill the required fields:

    • AI Action Agent Type: this setting only appears if you have access to Field Agents. If the option to select this doesn't appear for you, the type is set to Simple AI Actions by default.

      • Action Agent (Recommended): select this for an AI action that generates text in the column based on a prompt, cites sources, handles Excel files, and shows reasoning. This option is only available if Field Agents is enabled on your account.

      • Simple AI Actions: select this for an AI action that only generates text in the column based on a prompt. If you choose this option, you must include a reference to at least one column in your action details.

    • AI Action Name: enter the text that appears on the button used to run the AI action.

    • Description (optional).

  3. Under Action details, enter a prompt that describes what data you want to generate using AI. Type @ to reference columns and other sheets.
    ​

    ​

  4. Click Preview Results to view sample results. If you’re not satisfied with the results, return to the previous step and modify your prompt.

  5. Select Save AI Action.

AI actions can also be added to sheet templates and sheets inside engagement templates. Any AI actions inside a sheet carry over in an engagement rollover.

AI actions can be created by admins and any users who have been granted access in their permission settings.

If you’re not sure where to start, try the sample prompts below, or follow our guide for writing custom AI action prompts.

Suggest a test procedure

AI actions can reference your Control Activity and use this to create tests of controls. Here’s an example prompt to generate a test procedure:
​

For the control description, suggest an appropriate test of control procedure that an auditor should perform to evaluate whether the control is operating effectively. The test should be specific, actionable, and aligned with the control's intent. Clearly state the type of evidence to be obtained (e.g., inquiry, inspection, observation, reperformance) and the key steps involved.
Control description: {Control Activity}

Identify testing gaps

Here’s an example prompt to identify testing gaps: "Develop a test plan for the control in {control activity} and compare that test plan with the test plan from the prior year in {prior test plan}. Identify any gaps in the test plan."

Identify risks

Here’s an example prompt to identify risks: “Analyze {Control Activity} and identify three risks that should be reviewed by the audit team.”

Run an AI action

When a column has an AI action added, an AI action button displays on empty cells in the column. Click this button to run the AI action and generate data inside the cell.

Review the result and make any desired edits to the text.

Bulk run an AI action

To run an AI action down an entire column at once, follow these steps:

  1. Hover over the Run AI Action option inside the column's vertical ellipses menu.
    ​

  2. Select whether to run the action on All Rows or Empty Rows.

Additional examples

There are infinite possibilities for AI actions. Below are even more sample prompts to help you get started. Use these prompts as inspiration to create customized AI actions.

To add one of these AI action prompts to your sheet, follow these steps to create an AI action. The prompt examples below are what you'd insert under "write a prompt" in an AI action's settings. Change the wording of a prompt as needed.

Commonly used prompts

Name

What it does

Prompt example

Identify testing gaps

Drafts a test plan for a control and identifies testing gaps.

Develop a test plan for the control in {Control Activity} and compare that test plan with the test plan from the prior year in {Prior Test Plan}. Identify any gaps in the test plan

Identify risks

Identifies risks for a control.

Analyze {Control Activity} and identify three risks that should be reviewed by the audit team

Suggest a test

Drafts a test procedure for a SOC 2 control.

For the control description, suggest an appropriate test of control procedure that an auditor should perform to evaluate whether the control is operating effectively. The test should be specific, actionable, and aligned with the control's intent. Clearly state the type of evidence to be obtained (e.g., inquiry, inspection, observation, reperformance) and the key steps involved.

Control description: {Control Activity}

Prompts for drafting

Name

What it does

Prompt example

Draft recommendations

Assists with client recommendations based on audit findings.

Create a very brief recommendation to the following audit finding below on how the client can better meet the following control. Do not repeat the control or include a preface with the word recommendation, just write a short summary format that can be added to a report.
Audit Finding: {Audit Finding}
Control: {Control Activity}

Draft internal control

Rewrites a control as an internal control.

Rewrite the following question as an internal control: {Control Activity}

Draft walkthrough agenda

Drafts agenda items for control walkthroughs.

Write a very brief summary bullet list of agenda items to have a client walkthrough of this ISO control.
Control: {Control Activity}

Draft request

Drafts customized requests for evidence for clients.

Based on the following control and the following test procedures we have to perform for a PCI audit, write a request for evidence if the test procedure starts with the word examine, or a request for an interview if the test starts with the word interview, to be sent to the client for what is needed to perform the test.
​
Do not include a request for evidence and interview, just one. Start the request with the word "Provide" if the test procedure starts with the word "Examine". Start the request with the word "Interview" if the test starts with "Schedule an interview covering". Be brief.
​
Control: {Control Activity}
Test Procedure: {Test Procedure}

Prompts for audit program enhancements

Name

What it does

Prompt example

Improve control wording

Simplifies the wording of client controls.

For the following control, re-write it in a way that is easier to understand that a senior in high school could understand.
​
Control: {Control Activity}

Improve test procedure wording

Standardizes terminology: Rewrites test procedures in past tense to align with firm standards.

You are an expert in US English grammar.
​
Your task is to convert the following text to the past tense:
""""
{Test Procedure}
""""
Do not change anything other than the tense.
​
If there is no text, return: "No text provided"

Improve date format

Standardizes date formats.

Convert the following date: {Date} from YYYY/MM/DD to MM/DD/YYYY. Respond only with the date.

Prompts for quality checks

Name

What it does

Prompt example

Validate date ranges

Assesses whether two dates are within a certain time range. For example, if you want to know if an employee performed a specific action within 3 days of starting in their role.

Is Date A 3 calendar days or less excluding Saturdays and Sundays from Date B? Always respond with just Yes or No, do not provide an explanation. Date A: {Date A}, Date B: {Date B}

Prompts for risk identification

Name

What it does

Prompt example

Identify residual risks

Identifies residual requests based on a control and test results.

When considering the following control activity, and the results of testing its effectiveness, write a summary of any residual risks that should be noted. Write a short summary in one to two sentences.
Controls Activity: {Control Activity}
Results of Test: {Test Results}

Identify inherent risks

Drafts inherent risks associated with a client's controls.

In one to two sentences, write a summary of the inherent risks that the following control is helping to address. Control: {Control Activity}

Prompts for summarization

Name

What it does

Prompt example

Summarize walkthrough notes

Summarizes walkthrough notes and observations from individual site visits.

Consolidate and summarize (removing any duplicates) the following notes:
​
"""
{Site 1 Notes}
{Site 2 Notes}
{Site 3 Notes}
{Site 4 Notes}
{Site 5 Notes}
"""
​
If there are no notes, return: "No notes"
​
Otherwise, present notes in bullet list format.

Provide feedback

Providing feedback where you see ‘How would you rate this suggestion’ will allow us to fine tune the AI to make it as productive as possible for you—a simple click to thumbs up or down is all that’s required.

You can optionally give additional feedback after providing a rating. We'd love to hear your thoughts!

Did this answer your question?