PipedreamHQ / PipedreamHQ/pipedream

[FEATURE] Google Sheets - Add rows as plain text

Open
#8,539 1 comment 0 reactions 1 assignee Claimed by @jcortes View on GitHub
enhancement triaged
Dominant language
JavaScript
Stars
11.7k
Forks
5.8k
Avg merge
3d 10h
Merged PRs (30d)
102

Description

Hi,

Would like to request workflow V2 to maintain the feature of V1 by just adding the rows to Googlesheet as plain text.

Before:
Cell format before ex1
![image](https://github.com/PipedreamHQ/pipedream/assets/18277920/754d79dc-0e72-461e-a997-7672b31ae000)

After:
Cell format after ex1
![image](https://github.com/PipedreamHQ/pipedream/assets/18277920/e6f083a5-4adb-4568-9de5-5f75faf4ee8c)

To add another issue, I noticed that if the content paste is not in plain text.

Example,

Cell B11-B23 has formula to sum the values of column F based on the column B content.

The original formula of cell B2:
=SUMIFS($F$28:$F$687, $B$28:$B$687, $A$12)

After running the workflow V2, the formula valued changed and values not included in the summation.
=SUMIFS($F$29:$F$688, $B$29:$B$688, $A$12)

Please refer to the earlier effort on the request if needed: https://github.com/PipedreamHQ/pipedream/issues/8389

Thanks.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.