javascript - Google sheet automation - Stack Overflow

admin管理员组

文章数量:1187098

I am still up coming using Google sheets and coding. I have this project that I am working on. I want to extract certain columns and rows from a csv file and use them to build a table in Google sheet. I also want this process to be automated. I learnt that Google app script would be able to help me do this easily. Please how do I go about this?

I am still up coming using Google sheets and coding. I have this project that I am working on. I want to extract certain columns and rows from a csv file and use them to build a table in Google sheet. I also want this process to be automated. I learnt that Google app script would be able to help me do this easily. Please how do I go about this?

• javascript

Share Improve this question Follow asked Jan 25 at 14:29 BigefexBigefex 1111 bronze badge

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

You can start by reading into the docs here: https://developers.google.com/apps-script/guides/dashboard

This should help you familiarize yourself with using App Scripts within Google sheets. In its most simplistic form you can create functions to use on cells as you would built-in Google Sheet functions like =MATH or =LIKE

There is also google sheet Query functions to move data from one sheet to another on import which could help with automating when you add csv data into google sheets for the first time and want to start your analysis process: https://support.google.com/docs/answer/3093343?hl=en

In conclusion, one way you can accomplish this is to use queries to pull data in a format from one google sheet to another and then use app script functions in specific rows to give you endless possibilities through code to build tables or whatever you need from the data you have within the cell

本文标签： javascriptGoogle sheet automationStack Overflow