Navigate to[Frontly](https://frontly.ai/?ref=100nocode)and sign-up for an account.

Once you've signed up, click "**Add Data Source**" within the dashboard.

Select Google Sheets and follow the instructions to connect Frontly with Google Sheets.

Google Sheets
Connect your app to your Google spreadsheets to use as a database

Locate the Frontly CRM data file within your Google Sheets account and click "**Import Sheet**"\
\
The Frontly CRM data file you need to upload is located [here](https://docs.google.com/spreadsheets/d/1c2ZME4kV7AcO-gd30XaMbgDoLhGmtSm3-zIV9cvykyQ/edit?usp=drive_link). You'll need to download this file and then upload it to your own Google Drive.

Click "**Apps**" from the left-hand menu.

Create From Scratch
Manually add pages and sheets to create a new app from scratch

Name the app "**Leads**', add a unique subdomain name and click "**Create App**"

You'll automatically be taken to a new screen where you'll add your first app page. \
\
Click "**New Page**"

Add the page name "**All Leads**"\
\
This first page will display the information for all leads that are in your database.\
\
Click "**Create Page**"

Now you'll create your page by adding a Block.\
\
For this page, click the Table icon to add a Table Block.

Click the "Label" field in the top-left of the page and rename the Label to "**All Leads**"

Save the page. The save button is in the top-right corner of the page.

Click this icon to **go back to the Pages menu.**

Name this page "**Analytics Leads**" and click "**Create Page**".\
\
You'll now create a page within your CRM that only shows Analytics leads.

Click "**Filters**" in the left-hand menu.\
\
You're now going to configure a filter to only display leads that have been recorded with the Service Interest of "Analytics".

Ensure the "**Operator**" option is configured as "**Equals**"

Name the page "**Service Demand**" and click "**Create Page**".\
\
You're now going to create a page within the CRM that displays a bar chart of service demand.

Click "**Vertical**" as the **Variant** type and click "**Complete Setup**"

In the left-hand menu, **select "Service Interest" within the "Label Field" drop-down.**

Select "**Service Interest**" within the "**Group By**" drop-down.

Change the page label name to "**Service Demand**"

11
 
SEO
7
 
PPC
12
 
Analytics
10
 
Social media

You're now going to add a new page that contains a user input form. The user input form is mapped to the data in your CRM.\
\
Add the page name "**New Lead Form**" and click "**Create Page**"

Change the page label to "**New Lead Form**"

First Name
Surname
None
Business Name
Email Address
Service Interest
None
Save New Record

If you find that "Surname" has incorrectly formatted as a drop-down field type, you can correct this now.\
\
Click the "Surname" field to open the sub-menu on the right-hand side.

Select "**Input**" from the "**Display Component**" drop-down menu.

The "Surname" field is now configured correctly.

Now test your new lead entry form. Fill out all details on the form and click "**Save New Record**"

Head to your Google Sheet and you'll see your database has also been updated.

Congratulations! \
\
You've now created a custom CRM with four pages:

- A page displaying all data for all leads
- A page displaying all data just for analytics leads
- A page that displays service demand to date in a bar chart
- A form that allows you to quickly add new entries to your CRM\
  \
  Great work today!

Frontly

Google Sheets is a powerful online tool to help you do quantitative analysis. Learn how to use formulas to manipulate and analyze datasets, such as Google Sheets' COUNTIF and SUMIF functions, among many others.

Create a Custom CRM