## Lead Qualifier to Google Sheets

This template is designed to process user-provided leads by evaluating the lead based on the user's company description and lead rating criteria.

It starts by getting input text from the user and extracting the company name from a provided email. A branching logic checks certain criteria; if it meets the conditions, it takes the user through a series of steps involving Perplexity AI Chat, a rating process, and then adds a row to a Google Sheet. If the conditions aren't met, it bypasses the additional processes and directly adds a row to the Google Sheet. Finally, it concludes by outputting the flow's result.

# Examples

* * *

# Inputs

### Name

Elon Musk

### Email

elon@tesla.com

### Context

Wanted to automate his whole workforce

* * *

# Output

JSONText

```
{
  "then": {
    "919d307a-d2e8-4d28-9964-a74d0935f484": "**Elon Musk** is the CEO of **Tesla**, a leading company in the electric vehicle and clean energy industry. Musk has been at the forefront of pushing automation in Tesla's manufacturing processes, although he has acknowledged the importance of human adaptability alongside automation. Recently, Tesla has introduced thousands of Optimus humanoid robots to its factories, aiming to enhance production efficiency and versatility by enabling these robots to learn new tasks through video demonstrations and verbal instructions.[2][3]\n\n**Tesla** is a multinational corporation headquartered in Austin, Texas, with a focus on electric vehicles, solar energy, and energy storage products. The company is known for its innovative use of automation and AI in its manufacturing processes, and it continues to expand its technological capabilities, including the integration of humanoid robots into its workforce.[2][4]",
    "d73b73a5-69ec-4840-aa44-1645ffa8d755": {
      "Angle": "Buildship's low-code platform could enhance Tesla's automation processes by simplifying API creation and workflow management, aligning with their innovative use of AI and robotics.",
      "Name": "Elon Musk",
      "Summary": "Tesla is a leading multinational corporation in the electric vehicle and clean energy industry, known for its innovative use of automation and AI, led by CEO Elon Musk.",
      "LinkedIn": "",
      "Email": "elon@tesla.com",
      "Organization": "Tesla tesla.com",
      "Rating": "🔥High"
    },
    "645fc296-b138-47f8-b622-74bbf3aa255d": {
      "spreadsheetId": "1A0NnlGaDLoyDXQ1XwcSGaRe6tIRNNMJ6OrBOkfgBZho",
      "totalUpdatedRows": 1,
      "totalUpdatedColumns": 8,
      "totalUpdatedCells": 8,
      "totalUpdatedSheets": 1,
      "responses": [
        { 
          "spreadsheetId": "1A0NnlGaDLoyDXQ1XwcSGaRe6tIRNNMJ6OrBOkfgBZho",
          "updatedRange": "Leads!A20:H20",
          "updatedRows": 1,
          "updatedColumns": 8,
          "updatedCells": 8,
          "updatedData": {
            "range": "Leads!A20:H20",
            "majorDimension": "ROWS",
            "values": [
              [
                "🔥High",
                "Elon Musk",
                "elon@tesla.com",
                "Tesla",
                "tesla.com",
                "",
                "Tesla is a leading multinational corporation in the electric vehicle and clean energy industry, known for its innovative use of automation and AI, led by CEO Elon Musk.",
                "Buildship's low-code platform could enhance Tesla's automation processes by simplifying API creation and workflow management, aligning with their innovative use of AI and robotics."
              ]
            ]
          }
        }
      ]
    }
  }
}
```

# Lead Qualifier to Google Sheets

This template is designed to process user-provided leads by evaluating the lead based on the user's company description and lead rating criteria.