{"id":5018,"date":"2022-12-27T06:59:22","date_gmt":"2022-12-27T06:59:22","guid":{"rendered":"https:\/\/www.privyr.com\/blog\/?p=5018"},"modified":"2024-02-28T09:10:15","modified_gmt":"2024-02-28T09:10:15","slug":"how-to-access-and-import-wpforms-leads-to-google-sheets","status":"publish","type":"post","link":"https:\/\/www.privyr.com\/blog\/how-to-access-and-import-wpforms-leads-to-google-sheets\/","title":{"rendered":"How to Access and Import WPForms Leads to Google Sheets"},"content":{"rendered":"\n<p>If you already have a WordPress website, you\u2019ll want to add a contact form in it to support your sales and marketing process. A form makes it easy to collect leads for your business and receive important reviews and feedback. It can also play an important role in establishing your sales process in the right order.&nbsp;<\/p>\n\n\n\n<p>While there are many WordPress form builders you can use to create a form on your website, WPForms is one of the few trusted by millions for its effectiveness and excellent user experience. It\u2019s an easy and flexible form builder tool you can easily incorporate into your WordPress admin panel. It not only allows you to create forms but you can also use other WordPress tools and add-ons with WPForms since it\u2019s a part of the WordPress ecosystem.&nbsp;<\/p>\n\n\n\n<p>While WPForms is a great way to collect submissions from your website, how effectively you access and manage your leads afterwards can play a crucial role in taking your business growth in the right direction. And, to be able to do that, you\u2019ll need a reliable tool that supports the sales process where you contact and follow up with your client over a course of time. Google Sheets can be a great tool to support that process. If you\u2019re already using Google Sheets, you\u2019ll want to import WPForms data in it correctly.&nbsp;<\/p>\n\n\n\n<p>In this article, we guide you through the process of WPForms Google Sheets integration. Plus, we examine more efficient options to suit your business and device preferences.&nbsp;<\/p>\n\n\n\n<p><strong>Table of Contents: <br><a href=\"#H1\">How to access and download leads from WPForms<\/a><br><a href=\"#H2\">How to automatically send leads from WPForms to Google Sheets<\/a><br><a href=\"#H3\">How to get lead alerts for WPforms submission<\/a><br><a href=\"#H4\">How to receive and contact WPForms leads from your phone<\/a><br><a href=\"#H5\">Conclusion<\/a><\/strong><\/p>\n\n\n\n<h2 id=\"H1\">How to access and download leads from WPForms<\/h2>\n\n\n\n<p>Accessing leads and contacting them on time can be crucial to your business if communicating with clients plays a crucial role in your sales process. Luckily, with WPForms, getting hold of your leads is quite easy. The basic version of WPForms lets you store entries in the backend of your WordPress website. You can access them by logging in to your WordPress account and navigating directly to WPForms. If you want to view your leads, you can do it by clicking<strong> WPForms <\/strong>on the left-hand side of your Dashboard and then clicking <strong>Entries. <\/strong>You\u2019ll see a page where you can then view all the submissions made on your WPForms.<strong>&nbsp;<\/strong><\/p>\n\n\n\n<p>You can also download data from WPForms to your system easily by navigating to WPForms and clicking <strong>Export. <\/strong>It allows you to export multiple and single entries. Once you export what you need, click <strong>Download Export File.<\/strong> By default, most browsers will save the downloaded files to your computer\u2019s Downloads folder.&nbsp;<\/p>\n\n\n\n<h2 id=\"H2\">How to automatically send leads from WPForms to Google Sheets<\/h2>\n\n\n\n<p>Being able to automatically receive submissions of WPForms to Google Sheets not only saves you tons of time but also makes the whole process efficient. It ensures you do not need to visit your WordPress dashboard regularly to check if there are new leads. To set this up, you may require additional tools like Zapier (or similar connector software) unless you are subscribed to one of WPForms&#8217; premium plans. If you&#8217;re on the WPForms Pro subscription plan, you can automatically receive WPForms submissions on your Google Sheets with a simple setup as explained below:&nbsp;<\/p>\n\n\n\n<ol>\n<li>Once you\u2019ve installed WPForms, activate WPForms Pro<\/li>\n\n\n\n<li>Install and activate Google Sheets Addon<\/li>\n\n\n\n<li>Connect your Google account With WPForms<\/li>\n\n\n\n<li>Create a new WordPress form<\/li>\n\n\n\n<li>Configure Google Sheets Addon Settings on the form&nbsp;<\/li>\n\n\n\n<li>Publish the form.<\/li>\n<\/ol>\n\n\n\n<p>You\u2019ll now receive WPforms submissions on your Google Sheets automatically. However, the downside is that the basic (free) version of WPForms does not support the automatic syncing of submissions to Google Sheets.\u00a0\u00a0<\/p>\n\n\n\n<p class=\"has-text-align-left has-background has-very-light-gray-background-color\"><strong>Suggested Read: <\/strong><br><a href=\"https:\/\/www.privyr.com\/blog\/connect-facebook-leads-to-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to connect Facebook Lead Ads to Google Sheets<\/a><br><a href=\"https:\/\/www.privyr.com\/blog\/how-to-send-leads-from-wordpress-contact-form-7-to-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Send Leads from WordPress Contact Form 7 to Google Sheets<\/a><br><a href=\"https:\/\/www.privyr.com\/blog\/how-to-import-leads-from-jotform-to-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to import leads from Jotform to Google Sheets<\/a><br><a href=\"https:\/\/www.privyr.com\/blog\/how-to-connect-google-forms-to-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Connect Google Forms to Google Sheets<\/a><\/p>\n\n\n\n<h2 id=\"H3\">How to get lead alerts for WPforms submission<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"581\" src=\"https:\/\/www.privyr.com\/blog\/wp-content\/uploads\/2022\/12\/How-to-get-lead-alerts-for-WPforms-submission-1024x581.jpg\" alt=\"Get alerts for WPForms submission\" class=\"wp-image-5020\" srcset=\"https:\/\/www.privyr.com\/blog\/wp-content\/uploads\/2022\/12\/How-to-get-lead-alerts-for-WPforms-submission-1024x581.jpg 1024w, https:\/\/www.privyr.com\/blog\/wp-content\/uploads\/2022\/12\/How-to-get-lead-alerts-for-WPforms-submission-300x170.jpg 300w, https:\/\/www.privyr.com\/blog\/wp-content\/uploads\/2022\/12\/How-to-get-lead-alerts-for-WPforms-submission.jpg 1201w, https:\/\/www.privyr.com\/blog\/wp-content\/uploads\/2022\/12\/How-to-get-lead-alerts-for-WPforms-submission-300x170@2x.jpg 600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Receiving a submission alert for each lead is really helpful, especially when personal interaction with your clients is an important part of your sales process. It ensures you don\u2019t have to visit your forms library multiple times a day to view or download leads on one hand, and on the other, there\u2019s less chance of missing out on important leads. Fortunately, WPForms allows you to set up email notifications as soon as a user submits interest on your website contact form. You can set it up in just two steps.&nbsp;<\/p>\n\n\n\n<ol>\n<li>Open the form builder and go to <strong>Settings \u00bb Notifications.<\/strong> Here, you can access all of the notification options for your form. However, keep in mind that notifications are enabled for all your forms by default on WPForms.&nbsp;<\/li>\n<\/ol>\n\n\n\n<ol start=\"2\">\n<li>Input the email address where you want the notifications to be sent to in the<strong> Send to email address<\/strong> field. Though WPForms puts the default WordPress admin email in this field by pulling the administrator email from your settings, it\u2019s advised that you change the default recipient, or add additional emails. It ensures you receive notifications on your preferred email address.&nbsp;&nbsp;<\/li>\n<\/ol>\n\n\n\n<p>Additionally, you can use a connector tool to receive lead alerts on your CRM if you already have one. Integrate Zapier into your WPforms and configure it to send lead alerts on your CRM. If you want to receive lead alerts on your mobile, there are mobile-first CRM specially dedicated to helping you take care of your sales process from your mobile device.&nbsp;<\/p>\n\n\n\n<h2 id=\"H4\">How to receive and contact WPForms leads from your phone&nbsp;<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"581\" src=\"https:\/\/www.privyr.com\/blog\/wp-content\/uploads\/2022\/12\/How-to-receive-and-contact-WPForms-leads-from-your-phone-1024x581.jpg\" alt=\"Receive and contact WPForms leads from your phone\" class=\"wp-image-5021\" srcset=\"https:\/\/www.privyr.com\/blog\/wp-content\/uploads\/2022\/12\/How-to-receive-and-contact-WPForms-leads-from-your-phone-1024x581.jpg 1024w, https:\/\/www.privyr.com\/blog\/wp-content\/uploads\/2022\/12\/How-to-receive-and-contact-WPForms-leads-from-your-phone-300x170.jpg 300w, https:\/\/www.privyr.com\/blog\/wp-content\/uploads\/2022\/12\/How-to-receive-and-contact-WPForms-leads-from-your-phone.jpg 1201w, https:\/\/www.privyr.com\/blog\/wp-content\/uploads\/2022\/12\/How-to-receive-and-contact-WPForms-leads-from-your-phone-300x170@2x.jpg 600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>If you\u2019re running a sales process where communicating with leads through channels like WhatsApp or phone calls is crucial, you probably want a mobile-first CRM to manage your clients from your phone directly. It makes the whole process much more efficient as you don\u2019t need to go back and forth through different devices and software. Also, being able to contact your leads right away means you have a better chance of making a sale than contacting them late.&nbsp;<\/p>\n\n\n\n<p>The good news is that you have mobile-first tools such as Privyr that can help you access and process your WPForms leads effortlessly. What\u2019s even more exciting about this tool is that it offers much more than traditional tools such as Google Sheets. While Google Sheets is good for storing data and analytics, Privyr helps you automate your sales process from your mobile phone while taking care of your data perfectly.&nbsp;<\/p>\n\n\n\n<p>Here\u2019s how to integrate Privyr on WPForms:&nbsp;&nbsp;<\/p>\n\n\n\n<ol>\n<li>Log into your WordPress admin site<\/li>\n\n\n\n<li>Click <strong>Plugins<\/strong> in the left admin panel<\/li>\n\n\n\n<li>Click <strong>Add New<\/strong> in the left admin panel<\/li>\n\n\n\n<li>Search for &#8216;Privyr&#8217; to find the Privyr CRM plugin<\/li>\n\n\n\n<li>Click <strong>Install Now <\/strong>and wait a few seconds<\/li>\n\n\n\n<li>Click <strong>Activate<\/strong> once the installation is complete<\/li>\n\n\n\n<li>Click Privyr CRM at the bottom of the left admin panel<\/li>\n\n\n\n<li>Enter the Privyr Account Token, which can be found via the <strong>Account tab &gt; Integrations &gt; WPForms<\/strong> page on your Privyr mobile app.&nbsp;<\/li>\n\n\n\n<li>Click <strong>SAVE<\/strong>.<\/li>\n<\/ol>\n\n\n\n<h2 id=\"H5\">Conclusion&nbsp;<\/h2>\n\n\n\n<p>WPForms is a trusted form builder tool for your WordPress website, and there are different versions of it depending on your requirements. You can use the basic version to create simple forms with limited features around accessing and using them. Conversely, if you want advanced functionalities, you can choose to go pro. However, how you manage your leads once you collect them through WPForms is also an important part of your sales process. While Google Sheets can be a reasonable tool to store leads data and work around analytics, you may need a more efficient tool to streamline your steps around contacting leads, scheduling effective follow-up schedules, sending personalised messages, and managing data, so there\u2019s a better chance of closing sales with each lead.&nbsp;<\/p>\n\n\n\n<p><em>Privyr is a mobile-first CRM that helps you automatically import WPForms leads on your smartphone and WhatsApp them right away. It\u2019s a simple yet powerful tool that helps you automate your sales process through your smartphone, increasing your chance of selling in each interaction by 300%. Try <\/em><a href=\"https:\/\/www.privyr.com\/\" target=\"_blank\" rel=\"noreferrer noopener\"><em>Privyr for free<\/em><\/a><em> today.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you already have a WordPress website, you\u2019ll want to add a contact form in it to support your sales and marketing process. A form makes it easy to collect leads for your business and receive important reviews and feedback. It can also play an important role in establishing your sales process in the right<\/p>\n","protected":false},"author":6,"featured_media":5019,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[361,363,362],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.6.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Access and Import WPForms Leads to Google Sheets - Privyr Blog<\/title>\n<meta name=\"description\" content=\"Discover how to perfectly import leads from WPForms to Google Sheets across different devices and tools and improve the conversion rate.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.privyr.com\/blog\/how-to-access-and-import-wpforms-leads-to-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Access and Import WPForms Leads to Google Sheets - Privyr Blog\" \/>\n<meta property=\"og:description\" content=\"Discover how to perfectly import leads from WPForms to Google Sheets across different devices and tools and improve the conversion rate.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.privyr.com\/blog\/how-to-access-and-import-wpforms-leads-to-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Privyr Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/privyr\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-27T06:59:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-28T09:10:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.privyr.com\/blog\/wp-content\/uploads\/2022\/12\/Cover-Image-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1201\" \/>\n\t<meta property=\"og:image:height\" content=\"681\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Michael Ghimire\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@privyr_crm\" \/>\n<meta name=\"twitter:site\" content=\"@privyr_crm\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Ghimire\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Access and Import WPForms Leads to Google Sheets - Privyr Blog","description":"Discover how to perfectly import leads from WPForms to Google Sheets across different devices and tools and improve the conversion rate.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.privyr.com\/blog\/how-to-access-and-import-wpforms-leads-to-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"How to Access and Import WPForms Leads to Google Sheets - Privyr Blog","og_description":"Discover how to perfectly import leads from WPForms to Google Sheets across different devices and tools and improve the conversion rate.","og_url":"https:\/\/www.privyr.com\/blog\/how-to-access-and-import-wpforms-leads-to-google-sheets\/","og_site_name":"Privyr Blog","article_publisher":"https:\/\/www.facebook.com\/privyr","article_published_time":"2022-12-27T06:59:22+00:00","article_modified_time":"2024-02-28T09:10:15+00:00","og_image":[{"width":1201,"height":681,"url":"https:\/\/www.privyr.com\/blog\/wp-content\/uploads\/2022\/12\/Cover-Image-1.jpg","type":"image\/jpeg"}],"author":"Michael Ghimire","twitter_card":"summary_large_image","twitter_creator":"@privyr_crm","twitter_site":"@privyr_crm","twitter_misc":{"Written by":"Michael Ghimire","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.privyr.com\/blog\/how-to-access-and-import-wpforms-leads-to-google-sheets\/#article","isPartOf":{"@id":"https:\/\/www.privyr.com\/blog\/how-to-access-and-import-wpforms-leads-to-google-sheets\/"},"author":{"name":"Michael Ghimire","@id":"https:\/\/www.privyr.com\/blog\/#\/schema\/person\/035eb73824eaaa5da493bdcc004f3311"},"headline":"How to Access and Import WPForms Leads to Google Sheets","datePublished":"2022-12-27T06:59:22+00:00","dateModified":"2024-02-28T09:10:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.privyr.com\/blog\/how-to-access-and-import-wpforms-leads-to-google-sheets\/"},"wordCount":1395,"publisher":{"@id":"https:\/\/www.privyr.com\/blog\/#organization"},"keywords":["access WPForms leads","Import WPForms leads","WPForms leads"],"articleSection":["Sales Productivity Tips"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.privyr.com\/blog\/how-to-access-and-import-wpforms-leads-to-google-sheets\/","url":"https:\/\/www.privyr.com\/blog\/how-to-access-and-import-wpforms-leads-to-google-sheets\/","name":"How to Access and Import WPForms Leads to Google Sheets - Privyr Blog","isPartOf":{"@id":"https:\/\/www.privyr.com\/blog\/#website"},"datePublished":"2022-12-27T06:59:22+00:00","dateModified":"2024-02-28T09:10:15+00:00","description":"Discover how to perfectly import leads from WPForms to Google Sheets across different devices and tools and improve the conversion rate.","breadcrumb":{"@id":"https:\/\/www.privyr.com\/blog\/how-to-access-and-import-wpforms-leads-to-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.privyr.com\/blog\/how-to-access-and-import-wpforms-leads-to-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.privyr.com\/blog\/how-to-access-and-import-wpforms-leads-to-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.privyr.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Access and Import WPForms Leads to Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/www.privyr.com\/blog\/#website","url":"https:\/\/www.privyr.com\/blog\/","name":"Privyr Blog","description":"Helping sales professionals and businesses turn leads into clients","publisher":{"@id":"https:\/\/www.privyr.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.privyr.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.privyr.com\/blog\/#organization","name":"Privyr Blog","url":"https:\/\/www.privyr.com\/blog\/","sameAs":["https:\/\/www.facebook.com\/privyr","https:\/\/twitter.com\/privyr_crm"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.privyr.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.privyr.com\/blog\/wp-content\/uploads\/2021\/06\/Blog-Main-Header-Logo-100px.png","contentUrl":"https:\/\/www.privyr.com\/blog\/wp-content\/uploads\/2021\/06\/Blog-Main-Header-Logo-100px.png","width":100,"height":26,"caption":"Privyr Blog"},"image":{"@id":"https:\/\/www.privyr.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.privyr.com\/blog\/#\/schema\/person\/035eb73824eaaa5da493bdcc004f3311","name":"Michael Ghimire","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.privyr.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6bcc058898963032ea95712fad59096d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6bcc058898963032ea95712fad59096d?s=96&d=mm&r=g","caption":"Michael Ghimire"},"description":"A writer from the heart and marketer from the mind, Michael writes to help businesses implement effective sales and marketing strategies.","url":"https:\/\/www.privyr.com\/blog\/author\/michael\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.privyr.com\/blog\/wp-json\/wp\/v2\/posts\/5018"}],"collection":[{"href":"https:\/\/www.privyr.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.privyr.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.privyr.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.privyr.com\/blog\/wp-json\/wp\/v2\/comments?post=5018"}],"version-history":[{"count":8,"href":"https:\/\/www.privyr.com\/blog\/wp-json\/wp\/v2\/posts\/5018\/revisions"}],"predecessor-version":[{"id":8072,"href":"https:\/\/www.privyr.com\/blog\/wp-json\/wp\/v2\/posts\/5018\/revisions\/8072"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.privyr.com\/blog\/wp-json\/wp\/v2\/media\/5019"}],"wp:attachment":[{"href":"https:\/\/www.privyr.com\/blog\/wp-json\/wp\/v2\/media?parent=5018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.privyr.com\/blog\/wp-json\/wp\/v2\/categories?post=5018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.privyr.com\/blog\/wp-json\/wp\/v2\/tags?post=5018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}