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.**

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

Adding a data source

Creating an app

Adding an "All Leads" page

Adding an "Analytics Leads" page