N8n Form data to google sheet

Questions
1

Information on your n8n setup

  • n8n version: 1.77.0
  • **Database (default: SQLite):**SQLite
  • **n8n EXECUTIONS_PROCESS setting (default: own, main):**default
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):**npm
  • **Operating system:**Win 10

I am testing a basic from entry and inputting into google sheet.

I have the main document with

A1 = Company Name
B1 = Contact

When I run the workflow I am expecting the workflow to add a new sheet ( which it does ) then add the data ie company name & contact

But I get:

spreadsheetId sheetId title index sheetType gridProperties
1o_JrpYAMYKYFve9tW8j41ubc9pUQsg-qRLOquJkIg7w 1373677401 234 5 GRID {rowCount:1000,columnCount:26}

What am I not understanding here please?

2

In the second Sheets call you’re trying to add Company Name and Contact to the newly created, still empty, sheet.

If you want to do this, you can do so like below with an Edit fields.

Or specify the Sheet that it’s your first sheet, and not the newly created Client Name sheet.

- Milan, Consultant @ Automable.ai Free n8n consulting call

3

Great. Thanks for the help.

Is there a way to personalise the forms ?

Eg add a company logo / branding / colours ?

4

Happy to help! :slight_smile:

You can add HTML to the form description, so you can add a logo etc. there.

- Milan, Consultant @ Automable.ai

5

For anyone else that needs this

On the form submission I used

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
</head>
<body>
  <center>
    <img src="https://wilsea.com/pickandship.co.uk/logo1.png" alt="Pick And Ship Logo" width="200">
  </center>
</body>
</html>

On the form I used

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>Pick And Ship Customer Enrollment</title>
  <style>
    body {
      font-family: Arial, sans-serif;
      text-align: center;
      margin-top: 0;
    }
    h1 {
      margin-top: 20px;
    }
    img {
      display: block;
      margin: 0 auto;
      width: 120px;
    }
  </style>
</head>
<body>
  <img src="https://wilsea.com/pickandship.co.uk/logo1.png" alt="Pick And Ship Logo">
  <h1>Pick And Ship Customer Enrolment</h1>
</body>
</html>

Any way to change the colour of the horrible orange buttons

6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.