⭠ all tutorials

Export data from MySQL into a CSV in Google Sheets

Available for Unlimited All Access members only

Get access

If you’re trying to export data from your SQL server to Google Sheets, here’s a simple way to do that in a few minutes and without needing any technical knowledge.

After you create your actiondesk account you are brought to a screen of your workflows. Click “New Workflow” in the upper right hand corner.

sql to csv

Actiondesk will then ask you what data you would like to import. Click the MySQL logo or PostgreSQL logo or type into the search bar “MySQL” or “PostgreSQL” and select.  You’ll need to input your database name, port, host number, username and password. If you have trouble, you can read about that here. Then submit.

sql to csv export

Now that you’ve integrated MySQL or PostgreSQL, click the drop down arrow to the right of “Data Available” and select which set of data you’d like to access. In this example I’ll import the “dummy.customers” table. Now click “Import Data.” You can now choose which columns / attributes you’d like to import by clicking on “Select columns.” To import all of them, click on “Select All.” Then click "Confirm."

mysql export to csv
sql to csv

You’ll now be prompted with this screen again and you can click “Import Data.”  (You can also repeat the last step and import more data. It will be featured on a seperate “Sheet” just like the multiple tabs in excel or Google Sheets.”

mysql to csv

You’ll now be presented with data you chose to import from your relational database in spreadsheet form.

sql to csv google sheets

You’re almost done! Now you need to open your Google Sheets and label the columns you want (so actiondesk knows where to put the data in Google Sheets).

export to csv

Return to actiondesk and click “Program Actions” on the top. Choose Google Sheets (or the + button and add google sheets). You’ll be presented with 3 drop down menus. For the first choose “Create or Update existing row,” for the second choose the name of your google sheet (you’ll see a list of all your own google sheets) and next choose “Sheet 1” or whichever sheet its on in your own Google Sheet. Then click “Next.”

csv file export
sql csv export import

Almost the final step! You’ll now be presented with a screen with a few fields you’ll need to quickly fill. You can ignore the first field with the “Filter” box. For this example, I’m only interested in exporting the name of the instructor ID, customer ID,  and the Meeting ID.

I need to match up the corresponding fields so actiondesk puts the data in the correct column on my Google Sheets. For “Select Matching Key” I’ll type the name of my UNIQUE column heading in google sheets, which in this case is “Booking ID.” A meeting place, customer or instructor might be repeated more than once, but a Booking ID will not in this table.

You’ll see that actiondesk already suggests it for you. In the box to the right, type in the name of the corresponding column in actiondesk. In this case it would be “BookingId.”

sql to csv import

For the fields below, you’ll then do a similar action. Enter the name of the next column heading on Google Sheets (in this case, I’ve called mine “customer”) and the corresponding field name in actiondesk “customerID” After entering that in, click the + button to the right of this field. I’ll also add the instructor ID and Meeting Place. Then click save.

sql to csv

You’re now at your final step! Press “Run Once” in the upper right hand corner of the screen on actiondesk and now head on over to your Google Sheets to see your data (you may need to refresh the page).

sql to csv

To have this data update (every hour, every day, every week, or whichever you choose), you’ll need to click to click “Schedule and Publish” in the upper right hand corner on actiondesk. Choose how often you want it updated, turn workflow “on,” and press “Save.”

The full tutorial is available for pro members only

Request access

If you’re trying to export data from your SQL server to Google Sheets, here’s a simple way to do that in a few minutes and without needing any technical knowledge.

After you create your actiondesk account you are brought to a screen of your workflows. Click “New Workflow” in the upper right hand corner.

sql to csv

Actiondesk will then ask you what data you would like to import. Click the MySQL logo or PostgreSQL logo or type into the search bar “MySQL” or “PostgreSQL” and select.  You’ll need to input your database name, port, host number, username and password. If you have trouble, you can read about that here. Then submit.

sql to csv export

Now that you’ve integrated MySQL or PostgreSQL, click the drop down arrow to the right of “Data Available” and select which set of data you’d like to access. In this example I’ll import the “dummy.customers” table. Now click “Import Data.” You can now choose which columns / attributes you’d like to import by clicking on “Select columns.” To import all of them, click on “Select All.” Then click "Confirm."

mysql export to csv
sql to csv

You’ll now be prompted with this screen again and you can click “Import Data.”  (You can also repeat the last step and import more data. It will be featured on a seperate “Sheet” just like the multiple tabs in excel or Google Sheets.”

mysql to csv

You’ll now be presented with data you chose to import from your relational database in spreadsheet form.

sql to csv google sheets

You’re almost done! Now you need to open your Google Sheets and label the columns you want (so actiondesk knows where to put the data in Google Sheets).

export to csv

Return to actiondesk and click “Program Actions” on the top. Choose Google Sheets (or the + button and add google sheets). You’ll be presented with 3 drop down menus. For the first choose “Create or Update existing row,” for the second choose the name of your google sheet (you’ll see a list of all your own google sheets) and next choose “Sheet 1” or whichever sheet its on in your own Google Sheet. Then click “Next.”

csv file export
sql csv export import

Almost the final step! You’ll now be presented with a screen with a few fields you’ll need to quickly fill. You can ignore the first field with the “Filter” box. For this example, I’m only interested in exporting the name of the instructor ID, customer ID,  and the Meeting ID.

I need to match up the corresponding fields so actiondesk puts the data in the correct column on my Google Sheets. For “Select Matching Key” I’ll type the name of my UNIQUE column heading in google sheets, which in this case is “Booking ID.” A meeting place, customer or instructor might be repeated more than once, but a Booking ID will not in this table.

You’ll see that actiondesk already suggests it for you. In the box to the right, type in the name of the corresponding column in actiondesk. In this case it would be “BookingId.”

sql to csv import

For the fields below, you’ll then do a similar action. Enter the name of the next column heading on Google Sheets (in this case, I’ve called mine “customer”) and the corresponding field name in actiondesk “customerID” After entering that in, click the + button to the right of this field. I’ll also add the instructor ID and Meeting Place. Then click save.

sql to csv

You’re now at your final step! Press “Run Once” in the upper right hand corner of the screen on actiondesk and now head on over to your Google Sheets to see your data (you may need to refresh the page).

sql to csv

To have this data update (every hour, every day, every week, or whichever you choose), you’ll need to click to click “Schedule and Publish” in the upper right hand corner on actiondesk. Choose how often you want it updated, turn workflow “on,” and press “Save.”

If you’re trying to export data from your SQL server to Google Sheets, here’s a simple way to do that in a few minutes and without needing any technical knowledge.

After you create your actiondesk account you are brought to a screen of your workflows. Click “New Workflow” in the upper right hand corner.

sql to csv

Actiondesk will then ask you what data you would like to import. Click the MySQL logo or PostgreSQL logo or type into the search bar “MySQL” or “PostgreSQL” and select.  You’ll need to input your database name, port, host number, username and password. If you have trouble, you can read about that here. Then submit.

sql to csv export

Now that you’ve integrated MySQL or PostgreSQL, click the drop down arrow to the right of “Data Available” and select which set of data you’d like to access. In this example I’ll import the “dummy.customers” table. Now click “Import Data.” You can now choose which columns / attributes you’d like to import by clicking on “Select columns.” To import all of them, click on “Select All.” Then click "Confirm."

mysql export to csv
sql to csv

You’ll now be prompted with this screen again and you can click “Import Data.”  (You can also repeat the last step and import more data. It will be featured on a seperate “Sheet” just like the multiple tabs in excel or Google Sheets.”

mysql to csv

You’ll now be presented with data you chose to import from your relational database in spreadsheet form.

sql to csv google sheets

You’re almost done! Now you need to open your Google Sheets and label the columns you want (so actiondesk knows where to put the data in Google Sheets).

export to csv

Return to actiondesk and click “Program Actions” on the top. Choose Google Sheets (or the + button and add google sheets). You’ll be presented with 3 drop down menus. For the first choose “Create or Update existing row,” for the second choose the name of your google sheet (you’ll see a list of all your own google sheets) and next choose “Sheet 1” or whichever sheet its on in your own Google Sheet. Then click “Next.”

csv file export
sql csv export import

Almost the final step! You’ll now be presented with a screen with a few fields you’ll need to quickly fill. You can ignore the first field with the “Filter” box. For this example, I’m only interested in exporting the name of the instructor ID, customer ID,  and the Meeting ID.

I need to match up the corresponding fields so actiondesk puts the data in the correct column on my Google Sheets. For “Select Matching Key” I’ll type the name of my UNIQUE column heading in google sheets, which in this case is “Booking ID.” A meeting place, customer or instructor might be repeated more than once, but a Booking ID will not in this table.

You’ll see that actiondesk already suggests it for you. In the box to the right, type in the name of the corresponding column in actiondesk. In this case it would be “BookingId.”

sql to csv import

For the fields below, you’ll then do a similar action. Enter the name of the next column heading on Google Sheets (in this case, I’ve called mine “customer”) and the corresponding field name in actiondesk “customerID” After entering that in, click the + button to the right of this field. I’ll also add the instructor ID and Meeting Place. Then click save.

sql to csv

You’re now at your final step! Press “Run Once” in the upper right hand corner of the screen on actiondesk and now head on over to your Google Sheets to see your data (you may need to refresh the page).

sql to csv

To have this data update (every hour, every day, every week, or whichever you choose), you’ll need to click to click “Schedule and Publish” in the upper right hand corner on actiondesk. Choose how often you want it updated, turn workflow “on,” and press “Save.”

You must be a member to view the full lesson

Get started with
Makerpad today

The #1 platform for no-code education. Join over 10k others and discover what's possible.

Business

Multiple seat access, hire talent and custom training.

Learn more
Individuals

Unlimited all-access to our online bootcamps and community.

Get started
Email updates
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.

Tools used

Get help and discuss

Open community forum

Related lessons

Collecting recurring payments with involve.me
Collecting one time and recurring payments with involve.me
Calculating custom prices with involve.me
Making a calculator with involve.me
What is involve.me?
Send emails from Zapier and get analytics with Palabra
Marketing automation with Palabra, Bubble and Segment
Working with GraphQL queries in the API Explorer - 8base
Defining data tables and relationships in the data builder - 8base
How to setup a members-only Circle community (without a website) in Memberspace
How to integrate Circle (community forum) with Memberspace
Create Interactive Content with Outgrow
Target specific pages with a chatbox using Olark
Send emails from Airtable
Monitor content distribution on Twitter
Create a Welcome Bot in Slack
Dynamically Create Webinar Pages in Webflow
Create a social content scheduling workflow
Automating Newsletter Content in Mailchimp
Find and upload Instagram videos from by hashtag
Slack App That Scrapes Websites for Data
How to Easily Scrape Websites for Data using Autocode
Typeform - the basics
Airtable - the basics
Rank blog posts in Webflow by pageviews
Logic-based lead forms in Typeform
Dynamically generate Google Docs
Dynamically generate Google Slides
Weekly email digest of interesting links with Zapier
Automate + qualify your lead generation with Standard Library
Sentiment analysis of Instagram comments with Parabola
Subscription powered community like Patreon with Adalo
Referral marketing program
Automated sales reporting for Shopify with Integromat
Get data from an API with Parabola + Google Sheets
A calculator app in Boundless
Send SMS Surveys with Twilio + Airtable on Standard Library
📖 Visit your favourite blogs & save posts for later with Shortcuts
Automatically post content to Hacker News
Monitor and save posts from Reddit
Simple multiple-step form with Boundless
How to create an automated Google Sheets dashboard
Build a Mail Merge with Airtable, Gmail, and Standard Library.
How Superhuman Built an Engine to Find Product/Market Fit
How to create a SaaS website, CMS landing page & blog
From Coinmartketcap to Google Sheets without any code
How to automatically feed data to google sheets
Automatically get data from Mailchimp to your CRM
Creating an event check-in app
Enroll new users when they purchase
Browse all →

If you'd like this template, message @bentossell on Slack with your email for the account to send this template.