SMTP stands for Simple Mail Transfer Protocol, which is an Internet standard for email transmission available in Microsoft, Google and Yahoo! products among millions of mail servers worldwide.
Zoho Sheet is a cloud-based spreadsheet software that allows you to create, edit, share and collaborate on spreadsheets in real time.Zoho Sheet Integrations
It's easy to connect SMTP by Connect + Zoho Sheet without coding knowledge. Start creating your own business flow.
Triggers when a new row is created in a specified worksheet.
Triggers when a new workbook is created.
Triggers when a new worksheet is created in a specified workbook.
Triggers when the value of a particular column is set on both new and updated rows. The corresponding row data is returned along with this trigger.
Sends a plaintext email from a specific SMTP server.
Creates a new row in the specified worksheet.
Creates a new worksheet in the specified workbook.
Deletes a particular row based on its index.
Searches for a row/record in the specified worksheet based on some criteria.
Searches and then deletes a row based on some criteria
Searches and then updates a row based on some criteria.
Updates a particular row based on its index.
In this paper, I will be explaining about the integration of Zoho Sheet and SMTP by Connect. SMTP by Connect is a professional email marketing software that helps you to send bulk emails to a group of people or a single person at a time. So it is a great spution for your business. It offers a complete package to manage your contacts, segment them, build a list and send emails to them. In Zoho Sheet, you can create various spreadsheets and share them. The main benefit of SMTP by Connect integration with Zoho Sheet is, it eliminates the need for writing repetitive data from one application to another. This article will help you understand how to integrate Zoho Sheet with SMTP by Connect in an easy way.
Integration of SMTP by Connect and Zoho Sheet is very simple. If you are using SMTP by Connect services, then you don’t have to invest in any additional software or app for managing contacts. You can use it with Zoho Sheet. SMTP by Connect offers many ways to integrate it with other applications. It has its own API (Application Programming Interface. which is used for integrating it with other services. Apart from that, it has an option of importing data directly into your Zoho Sheet account.
Here is how you can integrate it with Zoho Sheet:
Step 1. Create a free account on Zoho Sheet. Sign up with an email ID and password.
Step 2. After signing up, select ‘Add new’ option in order to create new spreadsheet.
Step 3. Name your spreadsheet whatever you like. Select ‘Next’ button to move ahead. Now you can create cpumns in the spreadsheet according to your needs
Step 4. After creating cpumns, click on ‘Settings’ tab at the top. This tab allows you to specify the sheets that will be imported into the template. As soon as you click on the ‘Settings’ tab, you will see three options- ‘Import Contacts’, ‘Import Contacts with Email ID’ and ‘Export Contacts’. Here you have to select ‘Import Contacts’ option. Once you select this option, you will see two more options- import all contacts or import only selected contacts. Then, click on ‘Save’ button at the bottom of the page. This would save the settings for importing contacts into the spreadsheet.
Step 5. To start importing contacts into your Zoho Sheet account, you have to use SMTP by Connect API or import data directly into Zoho Sheet account using your existing email ID and password. For direct integration using SMTP by Connect API, copy paste below given URL in your browser address bar https://api.smtpbyconnect.com/?key=CLIENT_KEY&template=TEMPLATE&method=POST&contacts=CONTACTS&username=EMAIL&password=PASSWORD&resourceId=RESOURCE_ID&recordsPerRequest=RECORDS
You can find out your API key from your dashboard in SMTP by Connect account. Before copying the above mentioned URL into your browser, replace ‘ CLIENT_KEY ’ with your own API key and replace ‘ RESOURCE_ID’ with your own resource ID which can be found in your Zoho Sheet account. Replace ‘ CONTACTS/EMAIL/PASSWORD/USERNAME/RESOURCE_ID’ with appropriate values according to your needs and preferences. You can find out these values from your SMTP by Connect account’s settings page. Copy and paste above URL in your browser address bar and hit enter button after replacing all values with appropriate values. It will start importing contacts into your spreadsheet using integration between SMTP by Connect and Zoho Sheet.
The process to integrate SMTP by Connect and Zoho Sheet may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.