Have you transferred your data from Google Sheets to Airtable?  Try using the "Send Gmail" automation action and set up the email text as you've outlined in your screenshot

Hey @jordangeorgiou 

Sending data from Google Sheets to Airtable via Gmail is definitely doable using Airtable automations and integrations. Here's a quick approach:

• Google Sheets to Airtable Sync: First, create an integration between Google Sheets and Airtable using Zapier or Make.com. This will allow you to send data from your Google Sheet to Airtable automatically when a new row is added or updated.
• Airtable to Gmail Automation: Once the data is in Airtable, set up an Airtable automation to trigger an email via Gmail. You can format the email content to match the screengrab you provided by using Airtable’s email block and dynamically inserting fields from the records.

I have tried via 'long text & rich text format' but the formatting when emailed is off, or do you mean via another method?

Thank you.

The only thing is a new separate Google Sheet is made for each order, so how would I do that?

That works, or you could try formatting with a formula field and using that formula field in the email too; I find that's slightly easier to manage rather than trying to deal with it in the automation itself.  What was wrong with the formatting when sending it?  Could you attach a screenshot of what it looked like?