Is it possible to automate the creation of a table in MySQL from google Sheets?
Hello everyone I am new and I want to know if MAKE allows me to automate the creation of a table in my MySQL database from a google sheet, I want to take the headers from my google sheet, convert them into attributes in a table and then insert the data in an automated way, if any of you could guide me I would be very grateful.
Welcome to the Make community!
To do this, you can try using the MySQL “Execute a query (advanced)” module.
For more information, see https://www.make.com/en/integrations/mysql, and https://www.make.com/en/help/app/mysql in the help centre.
For more information on creating a table using SQL, see SQL CREATE TABLE Statement
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Thank you for all your support 