Getting Started with Make

• • Click Create a new scenario from the dashboard
• • Click the + button in the center of the canvas
• • Search for "Google Sheets" and select it

• • Choose Watch Rows as the trigger
• • Connect your Google account
• • Select your spreadsheet and worksheet
• • Set the trigger to check every 15 minutes
• • Map the columns (e.g., "Topic" column)

• • Click the + icon after the Google Sheets module
• • Search for "OpenAI" and select it
• • Choose Create a Completion
• • Create a connection using your OpenAI API key
• • Configure the module:

Model: gpt-4
Max Tokens: 500

Prompt:
Generate 5 creative content ideas for the following topic:

Topic: {{1.Topic}}

Format each idea as:
1. [Title] - [Brief description]

Make the ideas actionable and engaging.

• • Add another Google Sheets module
• • Choose Update a Row
• • Select the same spreadsheet and worksheet
• • Map the row ID from step 1
• • Set "Content Ideas" column to {{3.choices[].text}}

• • Click Run once to test the scenario
• • Review the execution log to verify data flow
• • Check your Google Sheet for the generated ideas
• • If everything works, toggle the scenario to ON
• • Save and name your scenario

Data Transformation Tools

Make includes built-in tools for manipulating data without code:

• • Iterator: Process arrays item by item
• • Aggregator: Combine multiple items into one
• • Router: Split workflow into multiple paths
• • Text Parser: Extract data from text using patterns
• • JSON: Parse and create JSON data

Error Handling

Add error handlers to any module:

• • Right-click any module → Add error handler
• • Choose from Ignore, Resume, Rollback, Commit, or Break actions
• • Send error notifications to Slack, email, or other services

Data Stores

Use Make's built-in data stores to persist information between scenario runs:

• • Store user preferences, conversation history, or cache data
• • Access via Data Store modules in your scenarios
• • Perfect for building stateful AI applications