Blockspring connects your spreadsheets to the web. Get data, use powerful services, and do things you didn't think were possible in a spreadsheet.
Can't find the template you need? Let us know, we'll make it for you.
Expand a long list of Google Short URLs in a spreadsheet
Given a list of company names, find most likely webpage and domain for each. * Used for enriching a list of company leads. * Great for Sales, Sourcing, or Research. Note: Blockspring bundles free Bing requests in its subscription here: https://open.blockspring.com/apps/bing_search_jobs?app_id=1.
Print and mail letters right from Google Sheets. * Great for businesses looking to automate direct user engagement. * You'll need valid To and From mailing addresses, as well as either a PDF or raw HTML for what your mail should say.
This template allows you to quickly identify over and under-performing pages on your site as well as acquisition channels. It can also be configured to show reports on: - Site performance (acquisition by browser, day of the week, screen resolution, page speed) - SEO performance (acquisition by landing page, referrer, keyword, and search engine) - Paid search performance (paid search end to end, and by keyword) Once set up, your reports will pull data from Google Analytics every hour to automatically stay up-to-date. To learn more about this template, visit [Coding is for Losers](http://codingisforlosers.com/acquisition-channel-report-blockspring-google-analytics/).
Search for a list of companies on LinkedIn given their industries, employee counts, and locations. Note: Blockspring bundles free Bing requests in its subscription here: https://open.blockspring.com/apps/bing_search_jobs.
Search for a list of people on LinkedIn given their company names, positions, and locations.
Retrieve domain authority, page authority, external equity links, and more for a list of URLs from MOZ. If you have a larger list of URLs in Google Sheets, this is a great template to enrich those URLs with metrics.
Given a list of itineraries, find the best flights and fares.
Automate data enrichment for companies. * Given a list of companies, this template will get social info and company information for each. * Great for users in Sales, Sourcing, and Market Research
If you work with a lot of Google Analytics accounts, this template lets you query all of them in a single report. You'll be able to set up metrics, dimensions, sorting, filtering, and even custom segments. This template also refreshes automatically every day to keep your report up-to-date.
Given a list of topics, pull hundreds of tweets for each and use Indico's machine learning service to identify common keywords.
This template will find locations, persons, or businesses associated with a list of phone numbers. You'll also identify the reputation score of each number and if it's on a do not call list. This is great for data enrichment and validation if you have a list of phone numbers sitting in a CRM or spreadsheet.
This template helps you find content ideas that have generated interest in the past, based on a topic of your choosing. It's a form of Skyscraper Analysis - a technique for link building & content creation in which you identify content that has performed particularly well (i.e. lots of social sharing or backlinks) and then try to create an even better version. One can reach out to the people who shared or linked to the prior art to see if they can get additional traction.
Automate your lead research to provide more personalized interactions and drive higher conversions. * Given a list of emails, this template will get demographics, social info, and company information for each contact. * Great for users in Sales, Sourcing, and Market Research As a next step, try combining this template with the output of List Building templates [such as this one that creates email lists](https://www.blockspring.com/templates/644f83f522cde5cd9d30c6d79fd23f2fd66e593b).
Given a list of emails, this template will get demographics, social info, and company information for each contact. * Automate your lead research to provide more personalized interactions and drive higher conversions. * Great for users in Sales, Sourcing, Growth, and Market Research As a next step, try combining this template with the output of List Building templates [such as this one that creates email lists](https://www.blockspring.com/templates/644f83f522cde5cd9d30c6d79fd23f2fd66e593b).
Set up a report that always stays up-to-date with your Postgres database. Enter a SQL query and an update frequency, and the resulting data will always stay up to date in your spreadsheet.
Given a company name, job position, and location, get a list of people that match on LinkedIn by doing a Bing Search!
Automate data enrichment for companies. * Given a list of companies, this template will get social info and company information for each. * Great for users in Sales, Sourcing, and Market Research
Print and mail checks right from Google Sheets. * Great for businesses looking to automate workflows (such as sending refunds). * You'll need valid To and From mailing addresses, and need to set up a Bank Account ID with Lob (instructions included)
Print and mail a list of postcards right from Google Sheets. * Great for businesses looking to automate direct user engagement. * You'll need valid To and From mailing addresses, as well as a PDF/image for the front of the postcard. You can customize the back with either a PDF/image, or a text message.
Track which companies are placing job postings each day on Indeed. This template is great for identifying and track growing companies. You'll be able to specify a location, a location radius, and a list of job roles to begin tracking. Blockspring will automatically pull in a fresh set of postings each day into your sheet.
Given a list of files on the web, download to Dropbox with one click. This template can save you a lot of time if you have a list of file URLs sitting in a spreadsheet, or if you're scraping links from the web.
Automatically get campaign-level insights from Facebook Ads each hour. * Retrieve basic insights for each of your campaigns within a date range. * Blockspring fetches new data every hour.
Free Heroku apps go to sleep every hour. This template will restart the dynos for a list of apps every hour to make sure they don't go to sleep. This is especially great for bots!
Find peoples' email addresses given a list of their first names, last names, and company name. * If you know the sort of people you want to connect with but don’t have their contact information, this template is your Golden Ticket. * Great for users in Sales, Recruiting, Design & Market Research As a next step, try enriching your email contact list with demographics, social, and company information to provide more personalized interactions (and drive higher conversions) using templates like [this one](https://open.blockspring.com/templates/5ed486c12e8dffd56d3853f66179fcb549698a4b).
If you work with a lot of Facebook Insights pages, this template lets you query all of them in a single report. You'll be able to pull metrics by post given a date range. This template can be set refresh automatically every day to keep your report up-to-date.
The template helps with Influencer Marketing, and idea that is fairly simple: find popular people that your target audience follows, and get them to recommend, comment upon, or use your product. Specifically, it can help you identify the top Twitter influencers within a topic area using Klout’s ranking. The template is deliberately simple, but has served as a good base to survey various related topic areas, such getting an estimated social reach or quickly summarizing the sort of content being shared by these influencers (let us know if you want to give it a try!). Once you’ve identified influencers, you can Tweet at them or use of some the other tools in the Blockspring arsenal to discover influencer’s email addresses and other contact information.
Perform a Content Audit to understand how well your content is being shared on social networks. Based on a blog homepage, import.io scrapes all the blog posts and the number of social shares is collected. This is a great way to do competitive research on other content producers, and to investigate your own content to look for opportunities for improvement. Coupling this information with web analytics can be even more useful, as you'll be able to understand how social sharing is/isn't involved in generating conversions on your site.
Track YouTube statistics for a list of channels. This template is great if you spend time exporting stats from multiple YouTube accounts for reports. You can even use Blockspring to schedule updates every hour, day, week, or month.
Can't find the template you need? Let us know, we'll make it for you.