Gallery

Useful Queries and Integration Packages for Most Common Use Cases

Synchronize Zoho CRM and Salesforce data

Synchronize SugarCRM and Zoho CRM data

Synchronize SugarCRM and Salesforce data

Synchronize Dynamics CRM and SugarCRM data

Synchronize Dynamics CRM and Salesforce data

Synchronize Dynamics CRM and Zoho CRM data

Create new MailChimp Subscriber from Salesforce Lead

Create new Salesforce Lead from MailChimp Subscriber

Create new MailChimp Subscriber from Salesforce Contact

Create new Salesforce Contact from MailChimp Subscriber

Create new MailChimp Subscriber from Zoho Contact

Create/Update MailChimp Subscriber from Zoho Lead

Create/Update MailChimp Subscriber from Zoho Contact

Create new Zoho Contact from MailChimp Subscriber

Create new Zoho Lead from MailChimp Subscriber

Create new MailChimp Subscriber from Zoho Lead

Create/Update MailChimp Subscriber from Salesforce Contact

Create/Update MailChimp Subscriber from Salesforce Lead

Create new MailChimp Subscriber from Dynamics CRM Contact

Create new MailChimp Subscriber from Dynamics CRM Lead

Create new Dynamics CRM Contact from MailChimp Subscriber

Create new Dynamics CRM Lead from MailChimp Subscriber

Create/Update MailChimp Subscriber from Dynamics CRM Contact

Create/Update MailChimp Subscriber from Dynamics CRM Lead

Create new QuickBooks online Customer from Salesforce Account

Create new Salesforce Account from QuickBooks online Customer

Create new QuickBooks online Customer from Salesforce Contact

Create new Salesforce Contact from QuickBooks online Customer

Create new MailChimp Subscriber from QuickBooks Online Customer

Create new QuickBooks Online Customer from MailChimp Subscriber

Create/Update MailChimp Subscriber from QuickBooks Online Customer

Create new Zoho Contact from QuickBooks Online Customer

Create new QuickBooks Online Customer from Zoho Contact

Create new Zoho Lead from QuickBooks Online Customer

Create new QuickBooks Online Customer from Zoho Lead

Create new Zoho Contact from QuickBooks Online Vendor

Create/Update QuickBooks online Customer from FreshBooks Client

Create new FreshBooks Client from QuickBooks online Customer

Create new Salesforce Opportunity from QuickBooks online Invoice

Create new Salesforce Account from BigCommerce Customer

Create new Salesforce Lead from BigCommerce Order

Create new Salesforce Contact from BigCommerce Order

Create new Salesforce Opportunity from BigCommerce Order

Create new HubSpot Contact from BigCommerce Customer

Create/Update Google Contact from FreshBooks Client

Create/Update MailChimp Subscriber from Google Contact

Create/Update HubSpot Contact from Google Contact

Create new Google Contact from HubSpot Contact

Create new Google Contact from MailChimp Subscriber

Create new Google Contact from Salesforce Contact

Create new Google Contact from QuickBooks Online Customer

Create/Update QuickBooks online Customer from Google Contact

Create/Update Salesforce Contact from Google Contact

Create new Google Contact from Salesforce Lead

Create new Salesforce Event from Google Calendar Event

Create new Google Calendar Event from Salesforce Event

Create/Update MailChimp Subscriber from FreshBooks Client

Create new Freshdesk User from MailChimp Subscriber

Create/Update MailChimp Subscriber from Freshdesk User

Create/Update MailChimp Subscriber from Magento Order

Create new MailChimp Subscriber from Magento Customer

Create new Magento Customer from MailChimp Subscriber

Create new Zoho Lead from Magento Customer

Create new Zoho Contact from BigCommerce Customer

Create/Update MailChimp Subscriber from BigCommerce Customer

Create new Zoho Lead from BigCommerce Customer

Create new MailChimp Subscriber from BigCommerce Order

Create new MailChimp Subscriber from SugarCRM Lead

Create new Zoho CRM Lead from HubSpot Contact

Create new HubSpot Contact from Zoho CRM Contact

Create new Zoho Contact from Marketo Lead

Create new Marketo Lead from Zoho Contact

Create new Salesforce Contact from Marketo Lead

Create new Zendesk Ticket from paid Shopify Order

Create new Zendesk User from Shopify Customer

Create new MailChimp Subscriber from Zendesk User

Create new Zendesk User from BigCommerce Customer

Create new MailChimp Subscriber from Shopify Customer

Create new Salesforce Contact from Shopify Customer

Create new Salesforce Lead from Shopify Order

Create new HubSpot Contact from Shopify Customer

Create new MailChimp Subscriber from Shopify paid Order

Remove subscribers with Shopify paid Orders from MailChimp

Create new Salesforce Lead from Shopify paid Order

Import Salesforce data to Dynamics CRM

Import Dynamics CRM data to Salesforce

Import Salesforce data to Zoho CRM

Import Zoho CRM data to Salesforce

Import Salesforce data to SugarCRM

Import SugarCRM data to Salesforce

Import Dynamics CRM data to SugarCRM

Import SugarCRM data to Dynamics CRM

Import Zoho CRM data to SugarCRM

Import SugarCRM data to Zoho CRM

Import Zoho CRM data to Dynamics CRM

Import Dynamics CRM data to Zoho CRM

Create new FreshBooks New (cloud accounting) Client from QuickBooks online Customer

Create/Update MailChimp Subscriber from FreshBooks New (cloud accounting) Client

Create/Update QuickBooks online Customer from FreshBooks New (cloud accounting) Client

Create new SendPulse Contact from Zoho Contact

Create new Google Calendar Event from Jira Issue

Backup your WordPress posts to Box

Create new Slack Notification when new WordPress Comment is added

Create new Slack Notification when new WordPress Post is created

Create new Google Contact from ActiveCampaign Contact

Create new Event on GoogleCalendar from ActiveCampaign Task Deal

Upsert Account

Top 20 Customers

Best selling products in current month

Popular Products

Orders by items sold

All Leads in current fiscal year

Leads by Source Campaign (in current year)

Campaign Budget vs. Actual Costs (By Fiscal)

Active Cases

Open Activities

Top Opportunities

Cases By Priority (Per Day)

Delete campaign's table data

Update "account" table

Emails with 'Completed' status

How many emails have been sent from your accounts

All payments collected

Bestsellers Products

Top 10 most expensive products

Customers By Orders Total

'Subscribed' email addresses

Email addresses filtered by names

Total count by List (Subscribed, Ubsubscribed)

Campaign Send Activity

Update Subscriber's information

Unsubscribe People from the List

Delete subscriber by email

List of all queries currently running on MySQL

Get records count for all tables in MySQL database

Adding a column after another within SQL (MySQL)

Get the list of tables in MySQL database

List of MySQL user accounts

Save MySQL results into a text or CSV file

Inserting multiple rows in a single MySQL query

List of all queries currently running on PostgreSQL

Show tables in PostgreSQL

Drop all tables in PostgreSQL

Inserting multiple rows in a single PostgreSQL query

Add an auto increment primary key in PostgreSQL

Account with last activity > 30 days

User's list

Contacts who are CampaignMembers

Sales By Accounts

Sales By account in 2015 Year

Sales By Accounts (by quarters)

Sales to Date versus Last Month

Increase prices by 5%

Delete all products

Stuck Opportunities

Delete some accounts

Get size of all tables in database

List the queries running on SQL Server

List of all tables in a database

Get all table names and their row counts

Implement LIMIT with SQL Server

Add a column with a default value to a table

Return the date part only from a datetime

Inserting multiple rows in a single SQL Server query

SQL Server subquery syntax

Customer Account List

Open Cases By User By Status (chart)

Open Cases By User By Status (with case's name)

Open Calls

Opportunities By Lead Source

Opportunities Won By Account

Update Accounts (email and phone)

Leads Created by Source this year

Leads created accross months

Potentials closing by this month

Potentials creation by months

Potentials created date VS their current status

Count of open potentials by stage