AI coding with GPT

Use AI in the Code node

AI generated code overwrites your code

If you've already written some code on the Code tab, the AI generated code will replace it. Ensemble recommends using AI as a starting point to create your initial code, then editing it as needed.

To use ChatGPT to generate code in the Code node:

1. In the Code node, set Language to JavaScript.
2. Select the Ask AI tab.
3. Write your query.
4. Select Generate Code. Ensemble sends your query to ChatGPT, then displays the result in the Code tab.

Feature limits

The OpenAi ChatGPT implementation in Ensemble has the following limitations:

• The AI writes code that manipulates data from the Ensemble workflow. You can't ask it to pull in data from other sources.
• The AI doesn't know your data, just the schema, so you need to tell it things like how to find the data you want to extract, or how to check for null.
• Nodes before the Code node must execute and deliver data to the Code node before you run your AI query.
• Doesn't work with large incoming data schemas.
• May have issues if there are a lot of nodes before the code node.

Writing good prompts

Writing good prompts increases the chance of getting useful code back.

Some general tips:

• Provide examples: if possible, give a sample expected output. This helps the AI to better understand the transformation or logic you’re aiming for.
• Describe the processing steps: if there are specific processing steps or logic that should apply to the data, list them in sequence. For example: "First, filter out all users under 18. Then, sort the remaining users by their last name."
• Avoid ambiguities: while the AI understands various instructions, being clear and direct ensures you get the most accurate code. Instead of saying "Get the older users," you might say "Filter users who are 60 years and above."
• Be clear about what you expect as the output. Do you want the data transformed, filtered, aggregated, or sorted? Provide as much detail as possible.

And some Ensemble-specific guidance:

• Think about the input data: make sure ChatGPT knows which pieces of the data you want to access, and what the incoming data represents. You may need to tell ChatGPT about the availability of Ensemble's Built-in methods and variables.
• Declare interactions between nodes: if your logic involves data from multiple nodes, specify how they should interact. "Merge the output of 'Node A' with 'Node B' based on the 'userID' property". if you prefer data to come from certain nodes or to ignore others, be clear: "Only consider data from the 'Purchases' node and ignore the 'Refunds' node."
• Ensure the output is compatible with Ensemble. Refer to Data structure for more information on the data structure Ensemble requires.

Example prompts

These examples show a range of possible prompts and tasks.

Example 1: Find a piece of data inside a second dataset

To try the example yourself, download the example workflow and import it into Ensemble.

In the third Code node, enter this prompt:

The slack data contains only one item. The input data represents all Notion users. Sometimes the person property that holds the email can be null. I want to find the notionId of the Slack user and return it.

Take a look at the code the AI generates.

This is the JavaScript you need:

const slackUser = $("Mock Slack").all()[0];
const notionUsers = $input.all();
const slackUserEmail = slackUser.json.email;

const notionUser = notionUsers.find(
  (user) => user.json.person && user.json.person.email === slackUserEmail
);

return notionUser ? [{ json: { notionId: notionUser.json.id } }] : [];

Example 2: Data transformation

To try the example yourself, download the example workflow and import it into Ensemble.

In the Join items Code node, enter this prompt:

Return a single line of text that has all usernames listed with a comma. Each username should be enquoted with a double quotation mark.

Take a look at the code the AI generates.

This is the JavaScript you need:

const items = $input.all();
const usernames = items.map((item) => `"${item.json.username}"`);
const result = usernames.join(", ");
return [{ json: { usernames: result } }];

Example 3: Summarize data and create a Slack message

To try the example yourself, download the example workflow and import it into Ensemble.

In the Summarize Code node, enter this prompt:

Create a markdown text for Slack that counts how many ideas, features and bugs have been submitted. The type of submission is saved in the property_type field. A feature has the property "Feature", a bug has the property "Bug" and an idea has the property "Bug". Also, list the five top submissions by vote in that message. Use "" as markdown for links.

Take a look at the code the AI generates.

This is the JavaScript you need:

const submissions = $input.all();

// Count the number of ideas, features, and bugs
let ideaCount = 0;
let featureCount = 0;
let bugCount = 0;

submissions.forEach((submission) => {
  switch (submission.json.property_type[0]) {
    case "Idea":
      ideaCount++;
      break;
    case "Feature":
      featureCount++;
      break;
    case "Bug":
      bugCount++;
      break;
  }
});

// Sort submissions by votes and take the top 5
const topSubmissions = submissions
  .sort((a, b) => b.json.property_votes - a.json.property_votes)
  .slice(0, 5);

let topSubmissionText = "";
topSubmissions.forEach((submission) => {
  topSubmissionText += `<${submission.json.url}|${submission.json.name}> with ${submission.json.property_votes} votes\n`;
});

// Construct the Slack message
const slackMessage = `*Summary of Submissions*\n
Ideas: ${ideaCount}\n
Features: ${featureCount}\n
Bugs: ${bugCount}\n
Top 5 Submissions:\n
${topSubmissionText}`;

return [{ json: { slackMessage } }];

Reference incoming node data explicitly

If your incoming data contains nested fields, using dot notation to reference them can help the AI understand what data you want.

In the second Code node, enter this prompt:

The data in "Mock data" represents a list of people. For each person, return a new item containing personal_info.first_name and work_info.job_title.

This is the JavaScript you need:

const items = $input.all();
const newItems = items.map((item) => {
  const firstName = item.json.personal_info.first_name;
  const jobTitle = item.json.work_info.job_title;
  return {
    json: {
      firstName,
      jobTitle,
    },
  };
});
return newItems;

Related resources

Pluralsight offer a short guide on How to use ChatGPT to write code, which includes example prompts.

Fixing the code

The AI-generated code may work without any changes, but you may have to edit it. You need to be aware of Ensemble's Data structure. You may also find Ensemble's Built-in methods and variables useful.