Neartail

Order form

Take food orders using Google Forms

WhatsApp form

Take online orders from your WhatsApp contacts

Payment form

Registrations, memberships, & bookings using Google Forms

Website builder

Create website with community features

Order form addon

Calculate order amount in Google Forms

Payment form addon

Accept payment in Google Forms

All products

Sell directly to customers & build your own brand

Formfacade

Customize UI

Change layout, hide fields & redirect on submit

Embed in website

Embed Google Forms in your website

Assign points

Assign different points for each answer & calculate score

File upload

Upload files in Google Forms without login

Autofill form

Transform emails into Google Forms responses using AI

Email notification

Email Google Forms response to your users & co-workers

All products

Enhance Google Forms into CRM

Formesign

eSignature

Collect legally binding signature in Google Forms

Fillable PDF

Generate customized PDF from Google Forms responses

Signature workflow

Collect multiple signatures in Google Forms

Intake form

Create intake forms that accepts eSignature from patients

HIPAA form

Mask PHI fields in email & links for HIPAA compliance

Prefill & email

Prefill Google Forms & send as email to customers

All products

Add legal & HIPAA compliance to Google Forms

How to sync orders to Google Sheets?

You can either sync Google Forms responses to Google Sheets or export Neartail orders data to Google Sheets.

Sync responses to Google Sheets
Login to Neartail. Click on the form to open it. Edit page will be displayed. In the Neartail Edit page, click on the form title to select it. Click on the gear icon next to the form title. Form settings will be displayed. Click Advanced. Click Launch to open Google Forms. In Google Forms, click Responses and click on the spreadsheet icon to sync responses to Google Sheets. All the fields in the form are included as columns and each row is a response. The responses will be synced in real time.

Export order line items data from Neartail Reports
If you used the Neartail templates to create your order form, then you will also be  able export the Neartail Reports data to google sheets. Login to Neartail > click on the form to open it > Edit page will be displayed > click Reports > click on the sync button in the bottom right corner. The responses will be synced to Sheets ONLY when you click on the Export button in Neartail. This includes order status, payment status & more.

When you sync the Neartail reports to Google Sheets, we create three sheets. (1) Order summary: This includes the customer contact details, amount and other fields in the form. (2) Order lineitems: This includes the order lineitems data. You can use the pivot table option on this sheet to create the aggregate reports you need. (3) Order details: This includes the quantity ordered for the products in each order. Each product will be added as a column. For products with variants, each variant will be a separate column.

Made with formfacade