Thursday, February 22, 2018

Copper CRM integrated contact us/sign up form for your website using Google Forms

Copper customers frequently ask us about setting up web forms that will automatically create a person (or lead) record and send a personalized email response upon submission.




Copper has posted a solution based on Wufoo and Zapier but it doesn't send an automatic email reply. It's also simpler and cheaper to use free Google Forms plus free Mailchimp, so we built it!

We loved this solution so much, we opted to use it on our own website.

Our live Contact Us Google Form: http://www.interlockit.com/Home/contact-us

If the email address submitted does not already exist in Copper, a Lead record is created instantly and a welcome email is sent using Mailchimp's Automated Welcome Email feature:

If the email address is found the phone number submitted is compared and updated if needed.

In both cases a Copper CRM Task is created to followup and is assigned to the user of your choice, plus Mailchimp sends a personalized welcome email.

You can even use Mailchimp to schedule automatic follow-ups, which is what we did for our Blink Reports Software Free Trial Sign-ups. This is another Google form we integrated to Copper CRM and to our Blink Reports for Xero Accounting software running in Python on Google App Engine/Google Cloud Platform. Mailchimp handles DRIP marketing to our free trial signups with a scheduled series of helpful emails.

In the case of the Contact Us Form 100% of the code runs inside the Google Cloud using Google Apps Script. The benefits are speed, simplicity, reliability, and security. It's all managed by Google's massive Cloud Computing resources and the world's best security team. All security for editing the online form and reviewing past form submissions in Google Sheets is managed by your existing Google Account logins.

Here's a code excerpt for the techies like me:

So what does it cost?

  • It's FREE if we can become your G Suite license Reseller for 10 or more users, which is at no additional cost to you.
  • Otherwise cost is $10 per month plus a small setup fee of $99 with discounts available for buying less than 10 G Suite users through us
  • Mailchimp is free for up to 2,000 subscribers or $10/month for unlimited emails
Certainly reach out to us at http://www.interlockit.com/Home/contact-us to sign up or send us any questions you may have!



Thursday, February 15, 2018

Google Drive Backup and Sync for Google G Suite

As we discussed in our prior post Google Drive Backup and Sync plus Google Drive Streaming both work great with your Google G Suite for Business account.

In this post we'll show you how to backup your documents folder, Quicken files, photos and videos with Google Drive.

Google Drive Backup and Sync can both Backup and Sync files to your computer but we recommend turning off the Sync feature and using Google Drive Streaming with your G Suite account. This avoids the consumption of hard drive space and the security risks of storing files locally on your computer.

Download Drive Back and Sync here: https://www.google.com/drive/download/backup-and-sync/ and run the executable to start the installation.

During the initial setup choose the folders you would like to backup, but don't turn on Drive Sync.

Your preferences should look something like this:

Note that we've chosen to backup various folders from the Home Theatre PC (HTPC) including my kid's local user directories where their valuable Minecraft levels are saved. 

We've also enabled the uploading of photos and videos to Google Photos. This way any new photos saved to the selected folders on the local drive from my Sony camera are automatically stored in Google Photos and accessible from any device anywhere, anytime. You can choose Original quality or the free unlimited High quality mode.

Note the "Removing items" option. If you want files you delete in Google Drive from the cloud or from the local computer to be deleted everywhere without prompting then choose "Remove items everywhere". You can also be prompted to remove items or you can choose not to delete items on other devices which may leave lots of orphaned files behind.

If you have a large amount of data to backup the initial backup could take many days to complete but once finished it will only upload the changes as they occur.

If your G Suite license is for G Suite Basic ($5/user/month) you can store up to 30 GB of files, photos (original quality), and emails. Upgrading to G Suite for Business will give you Unlimited storage for $10/user/month (1 TB/user if 5 or less users on the domain).


G Suite for Business at $10/user/month is one of the most cost effective unlimited storage options available since it includes the full G Suite of software, Google Vault and more in the price. Dropbox charges $10/user/month for 1 TB of storage but it does not include email, calendar, Google Docs, Google Meet video conferencing, Google Sites, etc.

Google Drive Backup and Sync is also an excellent replacement to Crashplan who exited the consumer backup space this year.

Certainly contact us at Interlockit.com for assistance or to upgrade to G Suite Unlimited storage!

Thursday, February 1, 2018

Backup and Sync for Google Photos and Google Drive plus Google Drive File Stream for G Suite

Are you confused about which Google Drive software tools you should install on your Windows PC or Mac desktop for use with your G Suite for Business account versus your personal @gmail.com account? If so, this first in a series of blog posts is for you.

Working with files purely in the cloud like Google Sheets, and Google Docs is the ideal way to go, but often we need to work with more traditional files stored on our desktop computer like photos, Microsoft Word/Excel, and accounting data like Quickbooks.

Google Drive Backup and Sync

Backup and Sync is an app for Mac and Windows PC's that backs up files and photos safely in Google Drive and Google Photos, so they're no longer trapped on your computer and other devices.

Backup and Sync works for both Google Photos and Google Drive. It replaces "Google Photos Desktop Uploader" and "Google Drive Desktop Sync." Please ignore the click bait headlines that created fears in our customer base that "Google Drive" was going to be shut down. Backup and Sync is the replacement and is an awesome upgrade of the legacy Desktop Sync utility.

As of May 2017 Google Drive had over 800 million daily active users and hosts over 2 trillion files. That's a massive growth curve from 120 million active users in 2013. Google Drive with its lower storage costs and included suite of software is a huge long term threat to popular file sharing solutions like Dropbox and Box.Net.

Google positions Backup and Sync as being for Personal users and Drive File Stream for Business users but using the two in combination has some big benefits that we'll dive into later. Backup and sync is their consumer sync client but G Suite organizations can use it too.

Google Drive File Stream

Drive File Stream lets you see all your files in Google Drive without using storage space on your computer. It behaves much like a traditional mapped network drive letter in Windows File Explorer or a Network Share in Finder on a Mac. It's a key improvement that is allowing our customer base to ditch Windows File Shares for good. Files are streamed to your PC from the cloud on demand for use in your favourite desktop apps.
Drive File Stream includes the ability to save specific files and folders offline, including Team Drives so you can still be productive offline without installing Backup and Sync. It's simple to open files like PDF's from Adobe Acrobat Pro and Microsoft Word directly from your Google Drive. Each time you press the Save button in your favourite app your changes are synced to Google Drive in the cloud. Version management is automatic so you can always roll back to a prior revision of your file.

However, Drive File Stream does not upload your images to Google Photos nor can you tell it to automatically backup your Windows Document or desktop folder from your PC. You can read more about the differences between them here.

On our next blog post we'll dive into installing Backup and Sync for G Suite organizations. In the mean time if you have any questions or would like pricing on Google Drive please contact us at Interlockit.com!